Search results

I have a text box 'TEXT52' on a report. THis is a calc. textbox here is what is in the control source: =IIf([Net]>0,[Net]) this works fine. so in the footer I want to sum any numbers in this column so I put a textbox in footer with this in control source: =Sum(IIf([Net]>0,[Net]) but it...

not sure It is a Command Button that is password protected, and it opens a 2nd form. Here is the code: Private Sub DataEntry_Click() On Error GoTo Err_Data_Entry_Click Dim strInput As String Dim strMsg As String Beep strMsg = "Please Enter Password For Data Entry"...

I have a couple buttons that when clicked ask for a password. When entering the password in the Input box, how Do you get it to display a * for each letter you type. I have to give a live presentation and I will have to enter the password. As it is now whatever I type shows in the box...

subform focus I have a subform named EmplErrorsSubform and to shift the focus to it I just used: EmplErrorsSubform.SetFocus

I have a combobox and 3 textboxes. THe 3 textboxes are populated depending on the number in the combobox. I keep getting the INVALID USE OF NULL error when the combo box receives the focus and then the user tabs to the next box without entering a number. But I want the user to be able to do...

Instead of using the database splitter wizard, can you just make a copy of db, then in the back end, just delete all the queries, forms, reports, and link the tables to the front end? Or is the splitter easier?

I have a textbox on a report that displays a total in a summary line. It looks ok till the numbers add up to 1000 or more and it displays: 1E+ 04 I tried the CanGrow prop. and the Format...Size..ToFit but not expanding to fit the numbers. I could just make the textbox...

I can't even open my db, keep getting 'Program has performed illegal operation' . But I can open holding shift key. I was coding some controls in a form when the error came up first time. Now I can't do ANYTHING with this form, can open in design view, but when I go to look at code the error...

Is it possible to have a print button that will print a report based on an active form? This is a form that is not tied to a table for any data entry I am not saving the data entered here. It is just a notice slip that I need to print.

Disregard, I got it to go. Forgot to put main form name before subform.

I have a main form with a subform on it. There is a command button on main form that opens a third form that when it opens, contains data from textboxes on both the main and subform and has a few new ones for added data. Problem is when I click command button I get errror 'can't find subform'...

I have a db that is used to track audited orders and the errors found in those audits. Well I have it almost ready for implementing and the way I set it up was the primary key in the main table was the carton number on the order. Well now mgmt says that it needs to be able to accept the same...

Thanks Rich. That got the max. It leads me to another problem. Is it possible to have all the controls on the form bound to the table, except 1 and have it bound to a table with only 1 field? So that when the report is printed, this Max value that I pull in and then add 1 to, will be saved...

Keep Getting : 'Expected As' Error at the G

I am trying to populate a textbox on a form with the max value in a field of a table. I am setting default value of txtbox to: =DMax([tablename]![fieldname]) and its not working. Is this even possible or wishful thinking? I am trying to pull in the max value, add 1 to it when I Click a...

I am trying to use a command button to open another database, only I can't get it to work. I am guessing it is possible and I just can't get the syntax. I tried in OnClick event: open G:/Adminsrv/Attend.mdb why isn't this working?

I am trying to put this type of an invoice number on a report. I need consecutive numbers each time this report is printed. I put a textbox called txtInv next to the command button used to print the report and hid it. Tried putting the following in the On Click Event of the print button...

Idjit- "And one note I didn't see specifically addressed - when you use a form to edit an existing record, you are changing the existing one, not adding a new one. And the changes are automatically saved, you don't have to do anything extra." As for the errors, it's not errors that can be...

WHen I click the binocs it says records not readable. I have data entry prop set to yes so the user can add entries easily. So they can only scroll as far back as the first one they entered in one session. And after 3 days there will be over 2000 records so scrolling on the form throught...

well I have the form that populates the table, but it is set for data entry. Can I use the same form to look up records or should I copy it and use a different form to look up records by emplID and make corrections/changes?