Search results

WayneRyan - Thanks for adding that. I learned something new today. pungentSapling - I have been searching for code to move the text boxes to specific locations on the reports, but have not had very good luck. Hope WayneRyan's reply helps you. I think I might rework some of my reports.

Simplistic but not the best. I am sure that someone else has a much better way of doing this, but here is what I have done in the past. Put all your fields on the report as you would like to see them. Make sure they all are set to grow. Decrease each text boxes height so the text box looks...

I am not certain if this is the best way, but this is what I did. I actually wanted to know when a user changed the data in any field in the form so I locked all fields. When a user wanted to edit data, they selected an edit button. The on-click even of that button opened a form where the...

ilir_ - I don't have access to SQL. Thanks for the suggestion though.

Thanks! Thank you very much for that link! It looks like it will be very helpful. Looks like today will be a learning day. :)

What makes library references disappear? We have been using this particular database for a while with no major problems. Then yesterday, of course after I left for the day, a user recieved a VB compile error - can't find project or library. We have run through this code every day. Why is...

Katy! Good grief. How funny, I grew up in Seabrook. El Lago to be exact. What a small world. I stay to chat, but this database is acting up again. This time it corrupted as someone was editing a record. Now that record doesn't exist. No worries since I have a back up from last night that...

Thanks Thanks Shep! The knowledge base article has given me a lot to think about. Right now, distributing the front end isn't an option. Most of the people working in the database are part-timers and I never know which computer they are going to be working on. I backup the backend every...

Somebody please help me. I am getting errors when opening my database that says it is not a database format and needs to be repaired. I seem to be gettting it more frequently lately as well. Here is my situation: I have 3 databases. One backend with all the data that is 25.7MB. One...

Thanks and help Thanks for this post. I think it is exactly what I need. Now, can you help me refine my code? This is what I have so far: Private Sub Command25_Click() DoCmd.SetWarnings (False) DoCmd.Close acForm, "DeleteForm", acSaveYes DoCmd.OpenQuery...

Help. My main form has a tab control of 4 pages, each with a form and subform. I added me.requery to the timer events of each main form of each page. The requery works but when it runs the user is sent back to the first record. I don't want that to happen. This is my new code: Private Sub...

I am confused on what my Val() expression is doing in my query. Can somebody try to explain this to me please? My database imports a text file and convernts most of that data into values. I have a query that has two identical expressions of Val([Calls]) where Calls is a text field and they...

I was read a post a few days ago about this problem. Someone suggested to check the tab order. If the first field in the tab order is near the bottom, that would cause the form to open at the bottom and not the top. Hope that helps.

I just began receiving this message when I run my database: "Cannot find the file 'L:\KeySupport\Certifications\Stats.mdb' (or one of its components). Make sure the path and file name are correct and that all required libraries are available." I have run this database just fine for at least 6...

Pat - Thank you for your help. I was certain that you would have something for me. I agree with your views on "intelligent" keys. This is just what those in charge wanted to see. Tim K. - I am in Texas, USA. Thanks for your help!

I am trying to create a "TripID" with the area of the trip and leave date. For example, say you are visiting the West on 7/5/02, I would like the TripID to become West070502. I have tried DatePart("dd",me.BeginDate) and I get this error: Run-time Error '5' Invalid procedure call or...

Has anyone come across a solution for this? I am wondering the same thing and cannot find an answer in any book or forum.

I had the same problem a few weeks ago. I could get get my report to format to columns, but not to hold that format. When I would restart, I was back to one column. Try this: Set up your report with columns as you would like it to appear. Then, go to Tools/Options/General and uncheck...

I have a make table query that pulls records from Table1 to Table2 based on criteria given by the user. The user updates those selected records in a form. I originally had a select query that prompted the user, but when I added code to the form to refresh it, the user was prompted for the...

What I would like to do is update one record in a table with a field in multiple records of a different table. Let me try to explain. Table1 contains 100 test questions with each question being a different record and having an unique ID number. (The info for this table is input with a...