Search results

Thanks pat! I've added the field [Fee] and added a text box on the form. It fills wonderfully when the BillingCode is selected. Just one last question. The fee is stored as a text value without the $ symbol. If I change the datatype of [Fee] to currency, it no longer gets updated from the...

Hmmm...didn't exactly work as planned. See, I need this to work on a subform. When I put the code into the OnOpen of the subform, it actually caused the entire form (including the parent form) to go to a new record. When I specified object name to the subform name, and then open the parent...

Thanks to both of you for your advice. A further questiont then: How do I get the fee stored along with the billing code? I will obviously need to create a new field in "tblClinical", right? Right now, I have a combo box listing all the billing codes with the type of visit next to it on my...

All the billing code info ([BillingCode], [TypeVisit], [Fee]) are listed in "tblBillingCodes". I use this table as a look-up value in the field [BillingCode] of my table "tblClinical". So, a specific code is stored in a record in "tblClinical". When I run my report of "tblClinical", I want...

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...

Rich, Thanks. It works great.

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...

Got it this time! Thanks Abby... it works perfectly.

Hmmm....not sure what you mean about the relationships. The tables are joined only on the StudentID number. The rest of the fields are different in each table. Right now the query is simple a select query containing all fields from all tables, and no specified criteria. So, it will return...

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...

Thanks Pat! I haven't actually tried it yet. Just wanted to know that is was possible before going out to buy a thousand dollar printer!

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!

Thanks! That works beautifully.

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...