Search results

Also I have posted a thread in the Tables Forum

I have taken some screenshots. Here are screenshots of my form in design view: Here is a screenshot of my code to hide all of the fields: Here are screenshots of the labels that are still visible: Thanks, Conner

HI, I have a database that will take lots of data entered by an employee and calculate some additional data and generate quotations. Within each quote there is a possibility for 15 different metals (5 Precious Metals, and 10 Base Metals). There is also 5 fields that need to be filled out about...

I do not think I want to create multiple Tabs because I want it to all depend on whether the employee needs to enter the information or not. I almost want buttons for the employee to either enter another metal, or move on to the next piece of information they need to enter.

thanks for the reply, There is a reason there are so many fields. This database is for generating quotations. Within each quotations there is a possibility for up to 15 metals (5 Precious, and 10 Base). Within each Metal, there are 5 Fields that need to be filled out. I am fairly New to...

HI, I have a form that in the OnCurrent event I want to hide a lot of the fields in the form because they will be used on an as needed basis. This form is based directly off of a table. I have used the visible = false code. There are 75 fields I need to hide. All of the fields are either...

I got it to work. I have no idea what I was doing wrong, or what I did to fix it. I just hope it doesn't go back to not working. Thank you for the help though. I was thoroughly confused.

HI, I have a form that is a popup. When I have the form in design view then change to form view, it opens as a blank. However when I open the main form in my database and click the button to open the popup form it opens with all of the elements showing. Why is this? Thanks, Conner

currently everything is just numbers and a dash that is in the input mast field.

I did not write the code. I found it on a website, but the poster did not have a copyright notice, so that is why there is not one there. However I had to go in and edit the code in several places to make it work for my needs. There are 10 zeros because that is how many total numbers there are...

I have already done all of that in the code above for the New QuotationNumber. I want to have the edits code be very similar, use the QuotationNumber and add a letter to the end of it and call it the QuotationNumberEdit or something like that. What would I need to change or add to the coded...

start with aa, ab, ac, and so on hopefully.

Hi, I have a database for quotations. The database automatically generates a new quotation number every time a new quote is started. This works great, and I am very happy. My next task is to allow the employee to pull up a quote that has already been generated and edit it. I would like for...

That came up a couple of times in the database as well. However, I fixed them and this feature seems to be working correctly. I will be able to test more as time goes on.

I had to add the field to the form, and delete it. It seems to be working just fine now. Thank you very much for your help.

I made the change, and not I am getting another error saying that "Database can't find the field 'QuotationID' referred to in the expression", but it is there.

The RecordID that you are referring to should be the QuotatoinID because that is the thing they are editing.

The form has nothing to do with the employees, other than the fact that the employees will be entering the data. I am not sure what you mean by control, and I am not sure if I can post the database.

the "EmployeeID" field is an autonumber in the EmployeeT table.

Yes, This gave me an error message "Database can't find the field 'EmployeeID' referred to in your expression."