Search results

Try Compress and Repair I have had a similar problem and the solution that I have found through talking with others here was to use the compress and repair feature. When you add, modify or delete table entries access does not automatically reset. Give it a try Hope it helps Jason

Hello All I was wondering if someone knew how to, when exported as .snp, to save a single report entry by a different name each time. What I have set-up is a form that has a button which transfers all data into a report, prints it and emails it. The problem I am having is when it is sent to...

Importing Guys As much as I'd love to import all of my files, I have tried. It will not import either. I will try the recovery program that you posted and let you know. Jason

Addition Just in addition to what I have already stated, I have downloaded some freeware that is supposed to recover the database. Well because it is freeware, it only recovered the tables (the easiest part to rebuild). Has anyone run into similar software that recovers Forms and Reports...

Good Day Everybody I have run into a very serious problem with my database and I hope that there is someone out there that can help. I was making some changes to some expressions for different print and save operations, when an error popped up "Rollback attempted". This then froze my machine...

Hey everyone I have a small concern when it comes to exporting a report into a Rich Text File. The exporting was easy, but I have one field (setup as a memo) with a large area to enter text. Within the report all text is visible, but when I export it only the first 6 lines appear. Is there a...

Install Problem Thanks for your quick reply. After I posted my last message, I tried playing around with it on a different PC. It works just like you guys said it would on my other machine. Could it be my main computer with the DB on it has some Access install issues? I am going to try a...

Spoke too soon Ok guys I guess I spoke too soon. When I change the field in the table from Text to Memo, I get an error saying "too many fields defined". Does anyone know what this means? Cheers Jason

Text/Memo Thanx guys, I thought it was going to be a simple fix. Too many codes running around in my head...steering away from the basics. Cheers Jason

Hello Everybody I wasn't sure where I should post this, so I chose here. This is a Newbie question, but I am only able to enter 255 characters in a field. The DB I have created needs a place where the individuals can enter a description of the scene they are attending. Is it possible to go...

Need a few more pointers Hi Wayne Thanks for the reply. Yours is an excellent idea, I'm just having a little trouble getting it to function appropriately. What I should say is I'm not quite sure where to insert the coding you gave me. So here is my code for opening the report. (report name...

Hello all I am working on fire dispatch form for our service and have run into a snag with Hide/Unhide macros when transfering data from a form to a report. What I have on the form is 3 option buttons that will hide or unhide certain fields as it pertains to different call types. Although...

Thanx for all your replies I guess I should have mentioned what these forms were for. I am building a Fire Dispatch report form. The reason I have 2 seperate forms is because we have 2 seperate Fire Stations that we need to track by Incident number. I will try all the suggetions that have...

Thanx for your timely reply Yes it is 2 seperate tables. Now not to sound like a pest, but could you give me some example coding that I should enter for an onopen expression? You could post here or email me at fireman_gcfd@yahoo.com Thanx again JDS

OK here it is as plain as I can put it without confusing myself. I am trying to get to forms to link together and use the same run of Autonumber between the 2 of them. (i.e. open first form and # would be 1...when I open the second form the number should start at 2) I have muddled my way...

Hey Mitch... Could you email me so I can send you a sample of my DB. I can't seem to get the funtions I need. An dsince you are the only one who seems to respond to my problems, I thought I would try to contact you for more help. jtspears@telusplanet.net It would be greatly appreciated jds

I posted a message the other day and I'm sure if I explained my problem good enough. What I would like to do is select a name from a combo box, and within the form in different areas (not in the combo box) have the rest of that persons information displayed in seperate fields.(i.e. address...

Heres my problem!! What I would like to do is when I select an employee from my combo box. Their information is displayed in the appropriate fields. Such as Phone #, address, workplace etc. The form I am building is an incident report form and I would prefer it if I would not have to type in...