Search results

Hello guys, I am working on a database that requires a user (with very little access knowledge) to export a table into .dbf (DBase IV Format) using a button and VBA. I realize this can be done by right clicking on a table and click export. However I did not give the end user access to the...

As the code suggested earlier, you should use -1 instead of 0, and then reverse the True and False back to it was previously: Private Sub Form_Current() Me.query_subform_subform.Form![txtFocus].SetFocus If Me.OrderCompleted.Value = -1 Then Me.query_subform_subform.Form![Order Quantity].Enabled...

You are correct, I misread that it was in a subform, sorry. To reference a subform control you use the following code: Me.subFormName.Form![FieldName].Enabled = False So... If Me.OrderComplete.Value = -1 Then Me.subformName.Form![Supplier].Enabled = False...

Hello, Go to Form properties, and under the events tab, click the three dots next to the "On Current" event and use the following code. I am assuming your checkbox is named OrderComplete, and that you have a few fields like Supplier, and OrderDate. Private Sub Form_Current() If...

Hello, I am not sure I completely 100% understand but here is my best shot. If you want comboboxes to filter each other, you may wish to look up "Cascading Comboboxes". To make these comboboxes filter the datasheet subform however, you can use the following code attached to a "search button"...

Hey, Sorry for the late reply, I'm not at work as much as I used to be. I am running it off of a network drive and it tends to be slow when more than one user is accessing the same table at a time. I have not found a good way around this yet. If you're running really slow and it's not on a...

Sorry for the double post, but to answer your FE/BE question, yes it is possible to make as many front ends as you wish. Once you split the database, the tables only are in the BE, and the FE links to the tables. You can create a copy of the FE, and name it adminFE or something similar, and...

This might not be exactly what you want... but it's what I do to control previous information from being edited. Under the form's "On Current" event, try something like the following code. Private Sub Form_Current() 'If a record exists (meaning it has a VidID) then the information is locked...

Am using Access 2003 and "Is Not Null" also works, both seem to work just fine.

Validation rule of "Is Null" means that the field has to be null in order to be accepted. Try "Is Not Null".

You're welcome! Glad it was helpful :)

Hello again, I apologize for being vague in my reply. Please go into your coding for the checkbox After Update and copy it (Highlight and CTRL-C etc.). Open up the your form in design view. Right click on the dark grey area outside of the form area, or in the little box at the top left, and...

Hello! I've recently had to deal with a similar thing, I put an edit button on the form, so the form has to decide for each record whether the edit button as pressed or not. Try copying your exact code into the Form's "Oncurrent Event". This runs that code on every new record. So when you...

Hello, The easiest way to do this would be to use a make table query, copying the information to a new table. Deleting the linked table and then rename the new table (regular table) to match the old linked one, this way the rest of the database that refers to the table will not need to be...

I agree with you completely that it's wrong to ask anyone to do your homework for you. Was just stating the amusement and adding insult to injury when something you need is right at your fingertips and you can't use it :)

We could have made the database for him. Make the database uneditable, and put the name of this website and our names on it. So he can't edit it... he can't pass it in... but at least he could visualize it ;)

100 dollars and I might consider... but I doubt it, doing someone elses work is just plain wrong. Learn the program yourself, or drop out of the class. I agree that this is not the career you should looking into, IT is all about learning yourself, and learning continually after graduation. If...

Awesome I'm glad that worked for you! Thanks for the compliment, I am a student in my final year of university for IT and work as a Database Analyst, so I am still learning too. There are many people around here that know more than me. This place was the best I've ever found for finding code...

Ok I am slightly confused here. You have a form that they select certain criteria from, and then a listbox only includes values that meets the criteria? You're giving my brain a workout today :) I assume your RowSourceType is Table/Query. Try using this line of code...

Awesome! Glad it worked, you're very welcome.