Search results

ok thanks anyways

I am making a QBF and I used the format on the ms access website to specify the criteria that will search for the filed on the form: Forms!FormName!ControlName Or Forms!FormName!ControlName Is Null This does what I want and works for a few fields, but the Or section automatically separates...

it's a table

Also, there is still inconsistencies between the records displayed in the form view and the records in the tables. For example, I have a duplicate record that appears when I scroll through the form (it is both record 3/10 and 4/10), but when I change any of the data in the fields both "records"...

I put all of the fields i would like to check for duplicates in the same code. I would like it to allow me to leave these fields blank though, and it can count blank fields as being identical too, or just ignore them. Here's my code so far: Private Sub Form_BeforeUpdate(Cancel As Integer)...

Ok, thanks. Do you know if there's a way to reset autonumbered fields to start back at one again? I am going to be deleting all the test data I made up while designing, and need the autonumbered ID field to reflect real numbers

We are auto generating our own part numbers so that they don't get repeated. The issue is that we have been using a sequential part numbering system in real life and it has to match that

Is there a way I can use a "find duplicates" query instead of an index? Maybe write macro to have it run before update, and then if it finds a duplicate, it will display an error message? The difference is with this other table, there may be a very similar part that will have all the same...

I am using bogus data right now too, but it would be nice to have the autonumbers start from 1 again once I start entering real data and delete the fake stuff. Any idea how to do this?

How can a user delete a record? I want to restrict user access to the form level, but htey need to be able to edit and delete records I tried putting a command button on my form that could delete the record, but this failed to update my tables. What's worse, it only deleted the record from my...

How can a user delete a record? I tried putting a command button on my form that could delete the record, but this failed to update my tables.

OK, so WORKORDERS is your table, and you selected all the fields you wanted in the report by using SELECT. And the user enters the specific radio unit and the start and end date. So this code gives you a pop up message? Where do you put this code? I haven't used reports at all yet.

How do you create your prompts for reports? I haven't really looked into reports much, a query by form seems suit my needs, and I have found out how to put buttons on my query by form form that will open the form at the records that were specified. So the user can view the list of records in...

I am keeping our own unique part number as the primary key we have this for our own organization, but you are right it can have more than one mfr number. My database refernces the mfr and mfr part number. Do you only use forms to enter data? How can I show the results of a query in table or...

I do want the user to be able to edit data somehow in a controlled way. How do you suggest I do this? A report will just show the data. Is there a way of letting the user enter what info they want to see displayed in the report?

Also, if I am doing a query by form to allow the users to find records, it shows the results in table form. I should lock this so that they can't edit the tables right? But then I do want users to be able to edit data somehow. Is there a way to direct them to the form for editing the record...

Alright, I will give up on trying to make the database fool-proof. But right now, it doesn't have any real data in it besides test data. At what point in my design should I be splitting it into FE and BE? There may still be lots of fixing to do after I think it's up and running.

I would like to design the rules right into the relationships if I can, but I will probably do the FE and BE thing anyways after I am done designing. My form set up won't allow duplicate part numbers because it auto generates the next one, and I have set the type to default. Still it would be...

My database has a table called part numbers with a list of all part numbers, as well as the type of part. The part number is the primary key and should only correspond to one part. Then I have two (and eventually there will be more) tables that contain information for each part type. One is...

should I reinstall Access?