Recent content by AtLarge

Yes, that's it! I knew I had seen it before. Monday mornings. Thanks PBaldy!

Hi, I can add to my make table query UDate: Date() that will add a populated field to the output table that has today's date in it. I can also add something similar like this for example V_Num: [V_Number] and when ran, will prompt with a dialogue box to add some data, it will then create the...

DOH! Thanks Dude.

lol. I've been guessing and searching. :banghead: Take out the ampersand altogether? I tried moving it to the right side but no joy.

Hello, I created an update query to a text field in a table. However, it inserts the data at the end of the string and I need to insert it at the beginning of the string that already exists. How do I move it to the front instead of the end? :confused: This works but puts it at the end...

A field in a table can be populated by a lookup up but it has to be done manually or with a form. A "new" table can be created with a query that matches the data. Is it possible to skip these steps and create a field that automatically populates with the data from another table based on...

I have a Make Table query that has a Total: Sum of the field QTY. When I run it, the table data is correct but the field name is SumOfQTY. I would like to leave it as the original field name. Since it's in a unique table I'm not concerned with it being confused with another QTY field. How...

Thanks Pat. I was able to figure it out. When exporting I was always using the checkbox "Export data with formatting and layout" at the beginning. Leave that checkbox blank, browse for your path and file name, then click Ok Radio button "Delimited" and Next Radio button Tab Checkbox "Include...

I am running into a couple problems at the same time and could use some suggestions: I need to export a table to .txt I need to have the field names as well as the records Some records are part numbers with a leading zero like 043095 Some records are part numbers with dashes and alpha's like...

I appreciate the reply. I was reluctant to do this since it was working for me but not for them. I suppose what I can do is a screen share through communicator and then have them step through it so I can see what it's doing at the same time. Thanks!

Hello, I am trying to help someone long distance. Their db has tables in Share Point and one query in particular is kicking up multiple error messages. (we both have the same permissions) I ran the same db from my PC and it worked just fine. Since I cannot duplicate it I think it is some kind...

Yep, being a gringo I do tend to make my names long and I still use the prefixes in the descriptions. Guess I'll have to learn to let go of the old ways. :banghead: Thanks!

Or maybe even undock it? I know I can show it or not but sometimes it's in the way or not big enough. If I open it to show the full length of the names it makes the working window too small. Seems like there should be a way to move it to the bottom for example. Then you could see the full...

Ah... That's it! Thank you both. :)

I just want to automatically add a current date and or time stamp field to table whenever it is created so I know how fresh the data is. Is there an easy way to do this? :confused: