Search results

I'm upgrading a form that was designed a while ago (not by me). It has various text boxes/combo boxes/etc. and one tab control that has 3 pages (TabCtl87). It works fine, I want to leave it there. My goal is to create another tab control on this form with two pages. One will include combo...

So, in theory, I could set it up to save on enter in the field they will most likely be trying to update. That would create an error message when they can't enter data, yes? The problem is that it is very hard to recreate the record locking since it happens on a random basis for unknown...

The problem is they don't get any error. It just makes a lot of little "dings" when they try to type anything. Although, I suppose I could set it up to save the record when they enter a field, which I think would make an error message pop up. Hmmm... I'll try it. No thoughts on why the...

I have done some serious searching and have discovered that many others have posted this question, but I couldn't find any satisfactory answers. I have a FE/BE Access 2000 database in a multi-user environment. I have my default record locking set to "No Locks" (optimistic), but for unknown...

I am using an OpenForm Macro that filters on a parameter query to open a record in the user-friendly form view. The query prompts the user for the "job no." and then displays the correct record. It has worked fine, but lately it is failing to open records that I know exist. The macro has to...

I'd really appreciate it if someone could help me understand why my problem keeps happening and suggest a way to fix it: We have an Access database that runs on our network. Individual users have their own copy on their C: drives, and their tables are linked a master copy on a shared drive...

Works great, Thank you!

I have an IIf expression in a text box in my report. I want to sort by the result. I can't sort by the field in the expression, because it has many different possibilities that aren't important in this context. How can I do this? I've tried lots of different things under Sorting/Grouping, but...

I have a series of reports, all of which are sorted by a job number, and which include very important dates. The problem is that suddenly the numbers stopped showing up on the reports. The text appears, the dashes in the dates appear, but no numbers. The computer in question is used for...

Ok, so I checked and both are text. I cleaned up the code a little and it stopped giving me the error, but it doesn't do what I want it to. I can still enter duplicate LS Numbers. This is what it looks like now: Private Sub LS_Number_BeforeUpdate(Cancel As Integer) On Error GoTo...

I'm pretty new to Access, so please overlook any stupid questions :) I have a data entry form that has one field that cannot be a duplicate. So, in the table I have it Indexed with No duplicates. The problem is that the form doesn't notify the user that they have entered duplicate information...

Ok, so I'm pretty new at this stuff, and while I'm sort of familiar with VB, I feel like there should be a fairly simple expression that could solve my problem. I have a calculated text box that is based on what is entered in another text box, like so: the source number is in a field called...