Search results

FRANKLY ... it has nothing to do with how long I have been posting. I take all comments with a grain of salt based on my experience and current knowledge. All comments are welcome, however, I resent the fact you had to put that in my face. :(

I never insinuated Pat did not know what she was talking about ... I am familiar with missing reference issues, and all references are in check. Now can it be that the reference are mapped wrong? Would they have been overwritten by the Office 2000+ installation ? How can I force them to...

Do you have any sample data in the tables ? QT = )

I am positive. It's occured on 3 different systems. I currently run the db on my PC, if I install Office 2000 or +, I will receive the error message. Then I uninstall the Office 2000 or + version and the error message appears! If I format the system, reinstall O97 it works great!! I DON'T...

My client runs an estimating DB in Access 97 ( I KNOW ... to no avail, I have failed to make them upgrade ) ... anyhow .... Here is my issue .... it has happened on 3 different systems so I am pretty sure I know what is causing the problem. Any system that has, or has had Office 2000 and up...

Not Resolved ..... Still not resolved ... this is not makin' any sense .... NOT HAPPY .. :confused: AAAahhhhrrrggg ... spend so many useless hours on one little glitch .... moved on ... but I still need to figure out this mess. If any one else has some suggestion .... highly, HIGHLY...

Do you have any forms open and visible to the user when this query runs ? It's a little work around, but you can hard code an input box to request the SDate and EDate ... set this to an invisible field on the form. Then you can run your query based on these values that sit on the form, naked...

Sample data ... Partially, below is the data from the [DT: InventoryExend] table included in the SQL statement you requested: Part# CategoryID Description RP0046 30 ACRYLIC ROLL 75" W x 3/16" WHITE, LFT RP0043 30 ACRYLIC ROLL 63" W x 3/16" CLEAR RP0003...

There are no single quotes in the data ..... :confused:

Good stuff ... As they say ... leave something new everyday!! Thanks ! QT :D

All Good ..... HAhah ah ahaha ! I agree 110% !!!! Out of school I started working on some make shift db's and I tell ya ... I was PISSED at the MS's mediocre attempt at content help. This is why I found SysOpt.com ( I use mostly for tech ) and AWF.com ( founded recently via Google )...

Are those 3 sets of double quotes on each side of the string ?? I will try this ..... thanks for your suggestion QT :)

What does the Nz() function do?? Just curious ... I've been workin' with Access for about 5 years and I have never come across this function. Interesting .... I will DEFINATELY be utilizing this function in the near future. I have a work around ... but CHEERS to the Nz() function !!!!! :D...

yes, I tried the single quotations, does not work.

Search Criteria What is your search criteria ?? Or, do you want to be able to search on all of the above ?? QTNM

No room to argue .... RV .... "I tried quoting the single quotes as in the link you posted .... same error ... " - I did look into the link you posted, and I do appreciate it highly! In many cases, when I am having difficulty with a query I will throw it into a query builder and try to...

yes I understand that ..... I am showing him how the function works .... he can put it in a debug window to check how it works and play with it .... I agree .... s/he should refer to the field not the string itself. QTNM :rolleyes:

More specifically ..... left ( "HICX106-StandardTop-Venderedstest" , 30 ) *extra spacing for better readability! Hope that helps! QT :)

Not sure I understand ..... you want the Taylors at the top and then show also in the alpha listing at the bottom again ( in this case cuz it's the last in alpha order ). QT :confused:

Here's your coding for you .... Not sure what process you are going to use to run the code .... but here it is below ...... ( to test you can paste into a mod. and it runs great! ) Function RemoveSpaces() Dim T, I, C, Z T = "HICX108-Standard Top -Vendered" For I = 1 To Len(T)...