Search results for query: *

PHV, Worked like a charm. I unfortunately don't do enough vba coding to remember all the tricks from one time to the next. Thanks again. HCEONETMAN

I haven't seen this anywhere else, not sure why it doesn't work. I want to open a form with an underlying user table, then run a module to get the current username from the operating system, position on that user's record, then hide the form and proceed to a menu. This way I can refer back to...

jrabenhorst, You may have to change the "limit to list" value in the design of the underlying table, not just in the form. Open the table in design view and click on the 'Lookup' tab for the field. HCEONETMAN

CityChap26, Think of those who will come after you and have to support what you have written. (Of course your code will remain in use for years and need occasional updating). I find VBA somewhat easier to read and more easily modified, especially if future requirements increase the number or...

Remou, I tried to make this a standalone module so I could call on more than one event, though the same form will always be active when it is called. I'm sure it's something simple I've overlooked, but before I go further I will try to eliminate the need for this at all by forcing the value I...

Thanks Remou, but I get a compiler error "Invalid use of Me keyword". I tried it both exactly as above and using Rs_Bkmrk, which had been defined as an object. Either way the same error. Might I be missing a reference? I notice only 4 in use: VB for applicatios; MS Access 9.0 Object Library...

I have a form for purchase orders and a subform with payments against the PO in the parent record. If a payment type on the subform is identified as a closing entry, a piece of code runs which verifies that the amount entered properly zeros the balance. To do this, I open a recordset of the...

PHV, I didn't see the earlier post, sorry. It worked like a charm. Syntax can be a wonderful thing when done right. (Unlike a 'sin tax'). A star to you, and thanks to you and Traingamer. HCEONETMAN

Greg, Based on debug.print statements placed in the code, the value in str_DESIGNATN matches the item I've chosen on the screen. The statement "rst.FindFirst "[DESIGNATN] = " & str_DESIGNATN" is the first one that fails to execute. HCEONETMAN

Traingamer, The problem is in moving to the correct record on the form. A query-by-form calls another form showing the hits. The user should scroll to the desired record and click the Exit button. Following is the code from the exit button which is supposed to return you to the original form...

I've looked at several threads and can't find the exact code to finish this. How do I move to a record on a form based on a value in a second form? The forms are not related, e.g. form/subform. There is a key field on the main form which also exists in the second form, but the records in the...

Naziern, I think what you would do is make the location combo box get data from a query based on the locations table. In this query you would set a criteria for the company_ref field to equal to the company ID in the control on the open form. Something like: company_ref =...

Nerdhurd, I don't know about Word, but if you have Adobe (not just the Reader) installed and the Adobe print driver is in your printers list, you can choose it as your printer and create PDF files directly from a report. Seems there should be something similar. I will experiment with going to...

Was the file on the local hard disk or are you on a network? On local disk, your only option may be to locate a file recovery program (Norton utilities, etc.) Most of them work from diskette to reduce the chances of overwriting the part of the hard drive that still contains the file. If you...

I have a database with a table of employees (key field Pay_ID) and a table of training classes (key field Class_ID). I'd like to create a simple form/subform where main form is the class (date, location, content, etc) and the subform would be employees in attendance. Where I'm stuck is I'd...

Roy-Vidar That's my oops. I used the expression builder, but chose the first reference to OCA, which was OCA_Code_Label. Looking further down I find the correct one, OCA_Code. I changed the reference and added the ".Value" to the statement in my last post and it works. Just to experiment, I...

Roy-Vidar, PHV, dboulos, kjv1611: Got off the track for a couple of days. Again, thanks for all the suggestions. Roy-Vidar's idea of using the expression builder was a great idea. After using that, I still get an error msg: "Object doesn't support this property or method". At least this...

PHV, I had also tried that, based on the MS link supplied by Roy-Vidar. The result is the same. To make sure, I copied directly from your post into the procdure (minus the trailing period). This is not make-or-break in my app, but still an annoyance that I can't get it to work. I appreciate...

Roy-Vidar That's put me on the right track. By experimenting with the syntax I can see when I'm referencing the correct form, then the correct form and sub-form, then form, sub-form and control. My code now includes: Str_OCA =...

I want to do validity checking on a field on a subform, but am a bit confused about how to refer to the field in VBA. The main form is "Frm_Receipts_Header_Admin" and the subform is "Frm_Receipts_Detail_Admin". I created a module on the afterupdate property of the field "OL3_Code". In the...