Search results

jdraw, I'm unsure if you're responding to me or Pat. My current database is not split at all. If I move to SQL, the BE would in SQL, FE in Access 2007. And I don't really want to put the FE on every PC this is used on. This database is used by multiple users (50+) in different locations...

Thanks for the explanation. I am considering moving the data back end to SQL and keeping the front end in Access. Do you think this would stabilize the database?

I have many databases on our network in Access 2007 that are used by multiple users. Most are fine, but one much-used database keeps making [databasename]_Backup.accdb files. This has been happening for sometime now. Today though there is ALOT of lost data in the database. The new database...

I used this code on a report. I put the code on a button's On Click event.

Thanks for the explanation! I really appreciate your help. Thanks again!

Sweet! Yes, that works great. What does "Nz" mean or do? And what is the "1" for? I looked in VBA help for "Nz" but found nothing. Thanks, thanks, thanks!!!

We have a telephone directory report in Access 2007. We would like to add a link to each staff person's photo. The photos are in a different location on our network, in our K: drive. On the Access phone report, the text box holds the field StaffName and the text box is named txtStaffName...

Here is what I figured out: I have to do this in two steps, I believe, because some of the records have letters in them. Even though the number ranges I am collecting do not have letters, Access won't let me change the data type in my new table. So, if I have my first query make a table with...

That wasn't it ... I removed the "/" in the field name and renamed the field to PONumNew and it still gives me the mismatch error...thanks for the suggestion tho!

The original data type is text and yes, it does include letters, but not for the ranges I am working with.

I have a text field that contains numbers that I want to change to a numeric field during a make table query. (Please note that I do not not have the option of changing the original table's data type.) (Also, I'm using Access 2000.) I've been searching forum posts and see people changing data...

Thanks, guys. I'm fried for today. Will give this another shot tomorrow. Thanks alot for your helpful suggestions!

Thanks for that ... I've been trying to find a way to strip the letters off front/back of the numbers. I surely appreciate your help!

Thank you for your reply ... I agree with you 100%. However, I think the problem is they don't even know what they've generated. And now it's on my plate to tell them...

I just found out that some of the po numbers have letters in front (e.g., R00001). This further complicates matters...

I have been asked to find missing records in a table for a purchase order number field. The ultimate goal is to give the user a report showing a list of these missing purchase order numbers. An example would be if the table has purchaser order numbers 00001 and 00003, but not 00002, they would...

Thank you! Yes, I did have a backslash (\) instead of a slash (/) in the calculated fields. I've changed it and it works now! Thanks again!

I have been searching thru these posts for help on rounding but haven't found an answer for my situation. I have a Form with unbound text boxes whose calculations that are rounding. All of the text boxes are unbound and are NOT fields that come from a table, so I can not set their field type...

The point is I need to check the records in the subform against the record on the main form to see if there is a conflict.

Thank you so much for your assistance; I'll give that a try.