If you already have a field showing the last recorded mileage on your form, just add an on exit event to the ServiceMileage field.
It should have something like:
Dim Response
if me.ServiceMileage < me.sfrmMileageMax then
Beep
Response = MsgBox("Mileage must be greater than last...
I do a lot of forms with multiple parameters. One of the things I do is set up a option buttons next to the combo boxes. Selecting it activates those parameters, deselecting it turns off those parameters. Create a public function that sets up your variables (I like to use Case statements...
I use # instead of 9's when I put designate an input mask (it would look like ####-##-##). They seem to work better. Have you tried it that way?
www.accessbrenda.com
I have a sales entry form for a small art business using Access 2003. My sales entry form is set up with "sales" being the whole sale, and "transactions" being a subform with individual transactions. The sales table contains the customer information, subtotal, sales tax, total, tender...
So, you definitively want to disable the cascading delete !
Well, not really. It would create a huge mess to have sales transactions hanging out there without a master inventory item to reference, and I have some code that relies on the cascading delete. As long as I force the user into NOT...
I found the problem. I was referencing the wrong field. The ItemCode field is NOT numeric. I forgot I had a separate numeric field for indexing.
Thanks.
www.accessbrenda.com
I don't really want to disable the cascading delete. The data is important in both tables, and I really don't want either of them deleted.
The itemCode has to be populated for the delete button to show up on the form, and all my ItemCode fields are numeric.
www.accessbrenda.com
Anyway, replace this:
If varResult Is Null Then
with this:
If IsNull(varResult) Then
Still getting the same result. I made sure my INVID in my query was set to numeric.
www.accessbrenda.com
I am enforcing referential integrity. That why I need to stop inventory items from being deleted - all sales transactions are deleted when that happens.
www.accessbrenda.com
One way I have done this, is all changes to inventory are placed in a separate table. I add field to mark the records as processed or unprocessed. My code calculates everything in the table that is marked as unprocessed. After the calculations are done, the field is updated to processed, and...
I am working on an sales/inventory program. I need to be able to stop the user from deleting inventory items in the Master Inventory that have matching sales transactions. I have placed a delete button next to the item in my inventory lookup form. This is the code I tried, and it didn't work...
Thanks. I'll give that a try. References is just one of those things I don't quite understand - especially why they are contstantly changing with each version! I'm sure it's just to drive us crazy.
Hmmm. I unchecked the missing library, and it all started working. Is there a way to avoid going through all this if the program is installed on another computer with a different version? I plan on selling this program.
I made sure both of those libraries were selected, and I still get the error. The only one showing as missing is 'Microsoft Office XP Web Components', and I can't find a replacement for that one.
When I first converted the database, I got an error that a reference was broken to owc10.dll...
I just upgraded from Access 2002 to 2003. In the new version some of my code is not working properly. I have a line of code:
varfirst = DLookup("AuthorFirstName", "authors", "author= " & Chr(34) & varauthor & Chr(34))
The Chr comes up with "Compile Error: Can't find project or library". Is...
I thought about that. But there are some reports that would be really annoying to HAVE to preview every time you printed them. There is also a lot of coding before and after the printing, and I really don't want to change that. So I really want an alternate method just for those few reports.
There are a number of reports in my database that I have programmed to print directly to the printer. However, if I begin distributing this program, other users may need to be able select different printers on their system for some of these reports. Is there a way to set up an interface...
Oh Wait! I'm sorry. I take that back. I was trying to look up a manufacturer that was in the OTHER database, but wasn't in MY database. It's working great. Think I'll change my combo box to only show records in my database. Thanks!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.