Replies

Simon,

Thanks. I had not thought of the alternative to IIF for the two logical fields. duh.

Do you have a suggestion for summing the following:
=IIf(([M_logPersonal]=False And [M_logVacation]=True And [chkFMLA]=False And [M_logRestrictedDuty]=True) Or ([M_logPersonal]=False And [chkFMLA]=False And [M_logVacation]=True And [M_logOverAge]=True),True,False)

NOTE: items prefaced with “M_” are fields in the query, items prefaced with “chk” are controls in the detail section of the report

Charlotte,

Thanks for feedback.

There are two Other tables involved:
tblBiped
pkey
strSSN
strcountry
strH1
strH2
strH3
dtmDOH
dtmTerm

tblOFI
pkey
fkey
strOFINumber
strSSN
strH1
strH2
strH3
dtmOFI

The user(s) do(es) not see the underlying tables, just the data, presented in forms and reports. They can change the value of any of the three labels, and then run reports or open forms and instead of “strH1”, “strH2”, or “strH3” printing, it prints the corresponding value from the tblLabels table. The names “label1”, “label2”, “label3” from tblLabels.strName should more appropriately have been named H1, H2, and H3, but this is an inherited project. There is probably a better way, but for now I am stuck with what I have. There about 20 folks using the existing version, and they want additional reports and forms. Ultimately it will be rewritten from scratch, with better practices and conventions, but initially I need to meet their immediate needs with minimal programming on our part (that is create reports and forms for the users using existing structures).

Does this make sense, or have I muddied the water?

Thanks for all your help. In addition to being brilliant, you are a kind person!

Ken

Charlotte,

Thanks for feedback.

There are two Other tables involved:
tblBiped
pkey
strSSN
strcountry
strH1
strH2
strH3
dtmDOH
dtmTerm

tblOFI
pkey
fkey
strOFINumber
strSSN
strH1
strH2
strH3
dtmOFI

The user(s) do(es) not see the underlying tables, just the data, presented in forms and reports. They can change the value of any of the three labels, and then run reports or open forms and instead of “strH1”, “strH2”, or “strH3” printing, it prints the corresponding value from the tblLabels table. The names “label1”, “label2”, “label3” from tblLabels.strName should more appropriately have been named H1, H2, and H3, but this is an inherited project. There is probably a better way, but for now I am stuck with what I have. There about 20 folks using the existing version, and they want additional reports and forms. Ultimately it will be rewritten from scratch, with better practices and conventions, but initially I need to meet their immediate needs with minimal programming on our part (that is create reports and forms for the users using existing structures).

Does this make sense, or have I muddied the water?

Thanks for all your help. In addition to being brilliant, you are a kind person!

Ken

John,

Thanks! I will give it test!

Ken

John,

Thanks! I will give it test!

Ken

Although there must be a cleaner and kewler way of deleting these records, I ended up using an update query and then a delete query. I added a field to the first table, updated the new field with string if it was to be deleted, then ran a delete query for all records that contained that string.

Although there must be a cleaner and kewler way of deleting these records, I ended up using an update query and then a delete query. I added a field to the first table, updated the new field with string if it was to be deleted, then ran a delete query for all records that contained that string.

Patt,

Thanks. I tried setting the relationship to the foreign key field (recordnumber) with no success. I even used a make table query to create a table of the records needing to be deleted, then create a delete query using the newly created table and the tblPayments table, relating to the pkey (a primary field) in both, and continue to get the same error. gggrrrrrrrrrrrrrrrrr! !!

Patt,

Thanks. I tried setting the relationship to the foreign key field (recordnumber) with no success. I even used a make table query to create a table of the records needing to be deleted, then create a delete query using the newly created table and the tblPayments table, relating to the pkey (a primary field) in both, and continue to get the same error. gggrrrrrrrrrrrrrrrrr! !!

Jerry,

thanks for you help. Unfortunately, some of their notes exceeded what Excel can handle in a single cell. So I just wrote this off as a learning experience, and hope they use Access, or Excel, instead of Word for these types of applications in the future.

We did play with replacing the carriage returns with a series of characters (i.e. “uuuuuuu” in Word) and then replacing the string with a carriage return, but too proved cumbersome, and slow.

Some folks think that because they have something in their computer, they have “automated” their office. Funny how sometimes, all this “automation” results in more work instead of less. On a positive note, at least they are not afraid of the technology and are pushing their envelops and trying to improve. Ya gotta love it!

Ken

Jerry,

thanks for you help. Unfortunately, some of their notes exceeded what Excel can handle in a single cell. So I just wrote this off as a learning experience, and hope they use Access, or Excel, instead of Word for these types of applications in the future.

We did play with replacing the carriage returns with a series of characters (i.e. “uuuuuuu” in Word) and then replacing the string with a carriage return, but too proved cumbersome, and slow.

Some folks think that because they have something in their computer, they have “automated” their office. Funny how sometimes, all this “automation” results in more work instead of less. On a positive note, at least they are not afraid of the technology and are pushing their envelops and trying to improve. Ya gotta love it!

Ken

Charlotte,

Thanks once again. I shall assign them punishwork, just like in school, and have them practice:

“Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,I shall never use Word as a database,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,I shall never use Word as a database, I shall never use Word as a database,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,I shall never use Word as a database, I shall never use Word as a database,I shall never use Word as a database, I shall never use Word as a database”

until they “get it”.

FYI – I went ahead and imported it via HTML, and they will use today as their start off with Access, and then clean up the memos on as as needed basis.

thanks,

Ken

Charlotte,

Thanks once again. I shall assign them punishwork, just like in school, and have them practice:

“Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,I shall never use Word as a database,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,I shall never use Word as a database, I shall never use Word as a database,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,Cntrl-C, Alt-Tab, Cntrl-V,Cntrl-C, Alt-Tab,I shall never use Word as a database, I shall never use Word as a database,I shall never use Word as a database, I shall never use Word as a database”

until they “get it”.

FYI – I went ahead and imported it via HTML, and they will use today as their start off with Access, and then clean up the memos on as as needed basis.

thanks,

Ken

Charlotte,

duh, sorry. Had tunnel vision and a bf at the same time.

thanks!

Ke

Charlotte,

duh, sorry. Had tunnel vision and a bf at the same time.

thanks!

Ke