Search results for query: *

Hi jbenson, That is an interesting solution, I had not thought of doing what you are explaining. I am going to give that a try as I think it would work. Thank You Dave

Hi jbenson, I do see how it is confusing. The prefix is based on products. So ZZ would be our widget product, XX would be product01, YY would be product02, etc. The 4 digits after the alpha is code for a process in the manufacturing of the product. The numbers after that have no specific...

Yes, once the number is created, I add the needed prefix and store it in a SQL server table.

Hello, I have unique prefixes depending on what user is working on. When user needs a new number, I query database, find the last entry, remove the prefix and generate my next number in sequence. There are times when users are needing to generate multiple sequential numbers for a prefix. As...

Duane, I went ahead and ran the update query and it worked. The PAMInfo.DwgNumID field updated. Curious why it did not show when I just did the view of the query. Anyway, I really appreciate your time in helping me solve this query. I learned something ans will be able to finish the other...

When I ran the query, the DwgNumID fields were blank. I know it ran through all the rows because at the bottom it showed the total records of 7271. I am wondering why it didn't update the fields? Does it matter if the PAMMain.DwgNumID field is an AutoNumber type? Thanks for you help. Dave

Thanks for you patience Duane. I have added FROM PAMMain to the query. UPDATE PAMInfo SET DwgNumID = PAMMain.DwgNumID FROM PAMMain WHERE PAMInfo.DwgNum = PAMMain.DwgNum I am now getting the following error and not sure how to resolve. Syntax error (missing operator) in query expression...

Thanks for you time Duane. PAMMain.DwgNum is already an unique index. I am going to include a portion of my table design to hopefully help. My relationship is the DwgNum field from the PAMMain to the PAMInfo. PAMMain DwgNumID AutoNumber DwgNum Text (Primary Key) EC Text Description...

No, it is still there. That is what is driving me crazy. See currently I am still using the DwgNum field to create the one-to-many relationship. Thanks for helping. Dave

Thanks for your help Duane. When I go to view the results of the query I get a prompt to enter PAMMain.DwgNum. I leave it blank and nothing happens. The unique index on PAMMain was DwgNum. I have changed it to be DwgNumID. I designed this table a about two years ago when I was learning, and I...

I have two tables. PAMMain has an AutoNumber field, DwgNumID. My other table, PAMInfo, originally didn't have a field that I could use to join via the DwgNumID. I have a problem where I need to create the DwgNumID field on my table PAMInfo so that I can use that field to join instead of the...

Is this a sub-form on another form? Are you using the datasheet mode or continuous mode on a sub-form and then a main form that is totaling items from the sub-form? Dave

I have an Access 2000 file that opens and runs fine with Access 2000, but when I try to open the file to look at the table or forms, Access 2003 crashes with in 5 seconds. It gives the VBE6.dll as the file that is causing the error. I have followed the instructions on the Access 2003 bug list...

MobSync is good and free http://www.pocketpcfreewares.com/en/index.php?soft=985 and you might look at MightySync also, but it is not free http://www.mydocsunlimited.com/html/mightysync.html Dave

These tend to be tough. Have you tried to soft reset the device and re-boot your PC? Also, when you went through the set up are you checking to see if activesync is looking at the right port? IT could be the cradle, but if it is the one that came from HP with the device you should be ok. Try...

PhatNotes states that it allows syncing multiple Outlook folders. Dave

I do not know of any 3rd party software that will do what you are asking, but you might take a look at PhatNotes. It uses a catergory style system I think. The standard version is supposed to sync with Outlook notes, but uses a catergory syle system instead of folders...

That is it PHV. That is the answer. Thanks so much. Dave

I am listing records in a listbox using SQL in VBA code. I am needing to filter the records by a column that has the following values "Complete", "Rejected", "Transferred", "Working", "Hold", or could even be Null. What I want is to only display the records that are not Rejected or...

What version are you using? Kaione has released an update, to version 2.5 and then almost immediately released a fix. http://www.kaione.com/