Search results

I want my combo box control to display two columns: BillingCode and Fee. Right now, BillingCode is stored in the table. I want the control to use the stored BillingCode and look up the appropriate fee, and then display both the code and the fee in the report. I've tried playing with...

I want my form to open to a new record each time...and I know I can do that by setting its DataEntry property to Yes. But, my form also runs an autofill function, where certain fields are automatically filled in depending on the values in the directly previous record. When I set data entry to...

I have a command button on my form that is hyperlinked to a second database. When the button is clicked, the second database is opened, but the AutoExec macro doesn't run. If I open the second db normally, the AutoExec macro is fine. Is there another way to open the second database from the...

I have a yes/no field that is used as a criteria to run an append query. When the field is set to yes, the record is appended to another database. Is it possible to set the field back to "No" after the query is run, so that it needs to be selected as "yes" before being appended again? Right...

I've set up a number of append queries to move records from an Active database to an Archive database. Once the records are moved to the archive, a delete query causes the cascading delete of those records from the Active db. Now, I also have an append query in my Archive db that can retrieve...

I want to stop a subform from moving to the next record or a new record after you hit enter or tab from the last field of that form. How can make it go to a new record of the master form instead? The master and sub forms are based on 2 tables with a one-to-one relationship so I don't want...

I have 4 tables set up with one table as the main table and the other 3 in one-to-one relationship to the main table. The main table contains student info (name, ID, etc.) and each of the other 3 tables contains info about a specific year of their program...tblOne = courses in year 1, tblTwo =...

Is it possible to put VBA code of some sort into my Access 2000 db causing it to automatically synchronize with a replica on a portable computer each time the db was opened or closed? The 2 files would be managed by MyBriefcase. Can VBA extend to the MyBriefcase functions? If so, does anyone...

I need to set the on-click property of a text box to complete 2 functions. Firstly, it must open a form corresponding to the value in the field. Secondly, it must close the current form. The code I have now does the 1st function perfectly. How can I add the Close form (current form name is...

Does anyone know if Acc2000 is compatible with any of the commercially available portable label printers? We are planning to have the DB loaded on a tablet PC and then need to print the reports on-site. Not really a development questions but hope someone can help!

I'm trying to create a command button on my form that opens a corresponding report. My problem is that I have a "data type mismatch in criteria expression." My code is this: DoCmd.OpenReport stDocName, acPreview, , "[ClinicalID]='" & Me![ClinicalID] & "'" The field I am using as the...

I've encountered a strange problem with one of my forms. The form contains a subform in datasheet view, listing all active patients in the database. There is a yes/no field, "ActivePatient", on the subform and is displayed as a checkbox control. I have not placed any enable/lock restrictions...

Here's what I'd like to do: I want to put a list box on my form that lists a variety of commonly used "comments". The user would then select a comment, presumably click some sort of button, and the comment would be pasted into a memo field named "Comments". In an ideal version, the user could...

What is the syntax for referencing a field on a subform? I know that for forms it is: Forms![myForm]![myControl] Would it be something like: Forms![myForm]!Subforms![mySubform]![myControl] Anyone who knows how to do this properly, your help is very much appreciated!

Ok. This might sound a little confusing but I really need some help! I have a form containing personal info (ie. Name, DOB, address, etc.) and a subform linked by PatientID that contains a record for each visit to the clinic. The two forms are each based on a table (main form = tblPatientInfo...

I'm trying to get the fields (text and boolean) on my form to autofill when a new record is opened. I would like each field to retain whatever value was in the previous record until the user decides to change the value. I've been trying to use the following code but keep getting error...

I've read all the previous posts on this topic but they don't seem to work for me. Here's my problem: I have a form set up that has PatientInfo in a main form and ClinicalInfo in a subform. I also have a report that has the PatientInfo as the main report and ClinicalInfo as a subreport. I...

I have a subform that displays a list of records based on a query. I'd like to double-click the "Name" field and have that result in the opening of a different form, "frmPhysician", but to that specific record. Basically, I want: double-click --> open frmPhysician --> goto [Name] record What...

I've been trying to use this code to get my forms to autofill based on the previous record. My data types include boolean, integer, and text. How do I modify the following code to reflect this? I'm just a very early beginner with coding! This is what I have now but it is not working: Dim...

I'm trying to get my form to autofill some of its fields based on the record immediately previous to it. I tried the module given in article Q136127 but I get this error message: "The expression OnCurrent you entered as the event property setting produced the following error: Type mismatch."...