Search results for query: *

Thanks everyone. Works great!

I also have negitive txn's. So Right("0000000" & Trim(Str([Amount]*100)),7) will not work, sorry I forgot to include this in the request. I do not want negitive sign included in the 7 digits. I have a seprate indicator field to define positive or negitive. Old Needed 146.36...

Thanks traingamer, but I do have values with 1 decimal place, will this work for that also? Here are some examples of what I have for values and what I need them to look like: Old Needed 146.36 0014636 145.24 0014524 6.1 0000610 13.1 0001310 93.63...

Hello, Im stuck and need some help formatting a field in my append-query. Example: 50.00 Need it to be at least 7 digits with leading zeros and no decimals So it would be "0005000" Also the field in my table were I need to store this value is TEXT. Does anyone know if this is possible? Mike

Works just the way I wanted it too. Thanks alot for the help. Mike

I think it can be done with docmd.domenuitem I just dont know what parameters to use with docmd.domenuitem( ) Anyone know?

hello, Im trying to find the code for creating a command button. I want the user to be able to click on the button and a new query design dialog pops up. Similar to what happens when you click new query in the database window. I want the user to be able select the tables needed for the new...

thanks, this will work!

Hello All, Im trying to write some code in VBA to check the current version on the users local pc against the server-side version. If the server-side version is newer then the local version, close the DB, update local version, and restart the lcoal DB. Does anyone know how this can be done...

Thanks, Im going to think about this some more and will get back.

Its not that the users are updating tables, multiple update and delete queries running. I would think that if multiple users click on the macro to run all the queries, that something would bomb. Thanks

That would not work, If I have 1 front-end all the users would be updating the same table? Need multiple tables so no users overlap others. Any other thoughts?

Hello All, A little background on what I am trying to do. I have a shell database that has 1 form and allows users to add/delete/import id numbers into a listbox. I then need to take these id numbers and run about 12 update queries. Since multiple users are using this at the same time...

Snyperx3: I tried Write #FileHandle, """ & rstOutput![SSN] & """ Does not work either. Maybe we could try a different exporting methoed? Is there any other Access commands to export into a csv file?

snyperx3, The CStr() function did not work? Any other ideas?

ddimond: The CSV does not have any quotation marks. snyperx3: The file I need to submit to a batch process requires a CSV file. Company Specialized Report (Batch Request) The Specialized Report allows you to select from a list of PDB Data Fields to create a customized report. Producers may...

The CSV files all output data but I need them to output as a text datatype. Right now when I open the CSV file in EXCEL the datatype is GENRAL. Is there a way when I am exporting to CSV to make sure that the datatype is text. The reason is, I have to then take these files and upload them as a...

hello all, I am stumped. I have the following code. I am trying to import only worksheets named "AGT" or "CORP" in 1 excel workbook. I am getting a data type mismatch error 13 when trying to get the worksheet name. Please see the code below. Private Sub cmdSplit_Click() 'Make sure user...

Works perfectly! Thanks alot!

Thank you for your help. I am getting a syntax error on this line: Output #FileHandle, rstOutput![ST], rstOutput![SSN], rstOutput![LASTNAME] I added the DAO 3.6 Object Libaray Any Ideas? Thanks, Mike