Search results

Hello, I have an Order form that has an Employee combo box with the list of employees from the Employee table. When I click and choose the name of the employee I get a message that "The field cannot be updated". But when I click OK button, it displays all information that is supposed to be on...

I have the same problem. Can anyone help on this topic? Thank you.

I am not even sure if this is a right place to ask something like that. But I thought you guys might have a recommendation for me. I need to put a signiture in one of my reports. How does one go about it? Do I need to buy a hardware or software for this? And if I do, can you recommend me the one...

Thanks guys for your help. Roy, you do have a valid a point about autonumber not being sequential. I guess, I will have to change that.

Yeah, I am using autonumbering for IDs only. It is a blank database, but i need to start Invoice numbers not at 0 but at 5000. Igor, is there any way just to assign something like that in Access without without writing a VB query? I know very little about VB and I would not even know where to...

Hello, I need to start autonumbering from a certain number(not from 0). How would I do that in access? Thank you very much for your help!

I was asked to fax a report from Access 2003. I have just read an article that I will need to create a macro, but it was for Access 97. Any changes since that? Also, from the Macro it looks like it changes the file format to RTF. Am I going to lose all graphics and formating when it faxes the...

That was it, Meltdown! Thank you very much!

I am sure you all figured out how bad I am at this since I have to ask this question :) . I have 3 different forms. 2 of them work perfectly well. My third problem is giving me a bunch of problems. I used to be able to type in information in different text boxes, but now I can only click in the...

Thank you for your reply, Peter. I am really new to this stuff, but I programmed in other languages. How do you call a function in access? Thanks!

Thanks, Newman. However, there should a more efficient way to do this rather than use a whole bunch of IIF statements. I would have to have an IIF statement for each possible range of the total. For example, I get a total that is $90 and want to round it to the nearest 100. I need an IIF...

Thanks for the help. Under which event for the text box do I need to code it?

I have a text box on my form that calculates the total of all purchases. I saw a rounding function in Access, but I need something that I can customize. For example, if the total order is $90, it would round it to $100, if the order is $19, 693 it would round it to $20K. Basically, it would...

Pat, Thank you for trying to help me. After I got your reply, I realized that I was so far off that I needed to figure out myself what to ask you. I found a place that was explaining VB for Access and your reply made sense and now I fixed the problem. Thank you for your help.

Thanks, Pat. Do I find the compound criteria in OpenForm's where argument under the Event tab in the form's properties?

MT, Thank you very much for your time and your effort to help me. I am sorry, I have been very busy and was unable to respond. I actually figured out the properties thing and all my child-master links seems to work fine. I am attaching my zipped database to explain what is not working. It must...

I am sorry, I am really new to this, I just started working with Access and I don't have a VB editor or know how to use it. Customer form is a parent CustomerOrder is a subform. At the bottom of the Customer Form I have a button that takes me the Order form. That form shows the correct CustID...

I have a CUSTOMER form with a CUSTOMER_ORDER subform, which basically shows all the orders by each customer. However, when I select one of the records in the CUSTOMER_ORDER subform and click on the order button to take me to the ORDER form, it always shows the very first record of the subform in...