Search results

I'm sorry. Here you go. Each user has his/her own version on a local computer Front end is 2010. The back end (all the tables) are on the server and shared. Network/server is hardwired. Thanks so much!

And it's hardwired....the connection bleeps alot though.

Yes, that is exactly how it's set up! We are in a world of hurt too....we keep entering stuff, running reports, etc. and the next day. The data is gone! That and it's locking up non-stop...have to compact and repair at a minimum of 10x a day! Any ideas?

Hello all, I have a database with a front end and back end (tables on the server) that was recently converted from Access 2003 to Access 2010. For some reason the back end keeps hanging and I have to constantly compact and repair and there has been major data loss on a regular basis. Can...

Hello, I have a database that I recently converted from 2003 to 2010 by creating a new database and importing everyting. I had an import spec in the old database that I used to pull in some customer text files and reformat however it didn't import into the new one. Where do I look in the old...

The column is populated with the customer id (auto generated) and customer name. The ID number is supposed to store itself in a separate table. It was working a-ok prior to me upgrading the database from Access 2000 to Access 2010. UGH

I was having trouble converting our database from 2000 to 2010 so I created a new database in 2010 format and imported everything. All seems to be working fine EXCEPT....there is one form that has one of the drop down boxes not working. The first drop down where you select the job number works...

It's there...statement works fine...just didn't type it all out. Thanks for the format part! Will try it!!

Hello all, I have a report with and iif then calculation in it. ie: iif([Text32-Text31]>0, 5.00) I need the result to be formatted like this 00000.00 so that it would return a number like this 00005.00. How do I put that formatting in the iif formula?? Thanks, Dianne

Thank you, I will try.

So, I need to run my clear records query, then my current append query to the 500byte table and then create yet another table & select query to make that field output properly?

vba, I cannot use the append query to do so because I cannot figure out how to pull all the data in and create a field that will auto number each line, hence, the auto number line in the table. Is there a way to make the table output the data in a certain format? Thanks, Dianne

I have an append query that throws data into a table which is then exported into a fixed width .txt file. That particular field is losing the format when exporting. :(

DCrake, Thanks again for all your help. I've figured out how to number the lines. I put an autonumber column in the table and it's working GREAT! It is formatted properly and everything. The problem now is that when I export it to a .txt file, it is losing the formatting which I am hoping...

No, I haven't run one - I'll do that. As far as the database though, it also has employee records, social security numbers, etc. in it so I'm just not at liberty to share it. :( I'm still thinking maybe the table could count rows and total or something? NO?

Or to the table?

Is there a way to shrink it and do that? We've been using it for years and it's 57,000 kb+. Can we add a field to the query that counts somehow?

DCrake: Thanks for helping. I set the basics of this up for another customer years ago and am having trouble remembering how I did it - that plus I have no idea how to make it count. Let me see if I can answer you below. The table has 52 fields as does the corresponding append query. There...

The append query pulls the data and appends it to a table. I then open the table and export the table as fixed width data, the result of which is posted above. I'll put it here again. Output of .txt file is as such: 1HCPT 11314 UBR ACFX072335TE080521682782...

Whew - this is over my head. lol I'm trying though. The append query throws the data into a table. I then open the table and export it to a fixed with .txt file that kicks out the 500byte line...for example: 1HCPT 11314 UBR ACFX072335TE080521682782...