Search results

And thanks for your help, this site has helped me out of a bind many a time. :)

My guess is you want the control box to show all the values once you're ready to go to the next record? If that is the case, then for Uur_AfterUpdate(), or wagenNr_OnGotFocus() whichever suit your purpose, use this code: me.wagenNr.setfocus me.wagenNr.dropdown

Couldn't fine it, but have managed to get it converted. Deleted all the link tables, re-imported them as normal table, then break the database into separate be and fe again.

Hey rural guy, where do I find the AutoCorrect option to turn it off?

You can call up the record using the employeeID or employee name, whichever is your PK, and print it. Just wondering, why not put the contract as a report in Access, then you can print that report instead of having to go to Word?

Just to piggy back on the thread, so how do we make the form popup in the middle of screen irregardless of screen size, and resolution?

Have tried compiling and taken care of all the errors, but still have the same problem. Could this problem be because I have linked tables to a be that have a database password? I doubt that is the cause, but I don't know ...

This will help you take out each part of the number, I named the field for the call number as "callNumber" Dim periodP, sortP1, sortP2, sortP3, sortP4, sortP5 periodP = InStr(1, callNumber, ".") 'position of period sortP1 = Left(callNumber, 2) 'the first 2 letter sortP2 = Mid(callNumber, 3...

Hi, I was trying to convert my database into a .mde, but during the process, there's a warning popping up saying: I know the strange name is the tables, because when I open my property window, some of my tables behind the forms or report is not shown with its name (the one I gave) but with...

Or hide the toolbar when that form is opened, and then unhide it when the form is closed? That will only take a few lines of codes.

I believe you can add excel library in access and then use that to work with excel, that way will give more functionality but requires more knowledge about codes, but here's a simple way: shell("C:\Test.xls") 'will open the excel file If you want to create a new copy of Test.xls before you...

Thanks. :D

From what I understand from your posts (which I'm afraid to say is not very clear to me), I don't think you need to use union query. Just putting the transaction as negative in the same table should do it. Keep things simple - that's my motto. Using union queries and what not when you don't...

So I have a check box and a combo box in my form, and if a user click on the check box, meaning they want an exchange, then I want the combo box to automatically drop its value, which is a list of reasons for the exchange, how do I do that? I feel just putting the focus on the combo box control...

Agree. And well working with ten field is just a head ache, and there's no reason to have it. If your serviceman can issue ten parts, then there's should be one record for each one that he issues.

I don't understand why you need to have ten fields for the various parts? Make all value that is entered in the outgoing stock form negative, for example: outgoingStock afterupdate() me.outgoingstock=-outgoingstock ? I think that should do it.

I suppose it depends on the kind of operation you want to do. I found keeping the two type of transactions separate was easier for both entry and reconciliation later. It only requires 1 or 2 query to calculate what's needed, even to list everything together. For me, the payment table was linked...

How about this: a lease table - customer, invoice No., charges, amount due etc A payment table - amount paid, time paid, invoice No., customer etc In query: sum of charges - sum of amount paid = amount still due. You can query by customer or by invoice number, so you will know when an invoice...

Honestly, I don't fully understand what you meant by "tie the incoming stock to the outgoing stock", maybe you can explain it again with examples of an operation you might want to do but have problem with?

Thanks. Will look through to see if it will do what I need.