Search results

1. been reading on here trying to find out what to use to solve a 3464 data type mismatch. I understand the error but have tried to fix it with 3-5 conversion functions including CInt, Val, Eval(Left(... etc. and nothing works. DoCmd.OpenReport "hieronly", , , "[hierarchy] = " & Chr$(34) &...

2003: I have a command button that has focus, can I hide it using "visible"?? I already tried .enabled=False and that doesn't work. How do I accomplish this or work around it? LostFocus Won't work.. How do I make variables "Global" so I don't have to keep redefining them in event procs...

Sub CurrentFormRecord(frm As Form) Dim lngrecordnum As Long lngrecordnum = frm.CurrentRecord End Sub ======================================= The code above is supposedly a way to store the current record of a table tied to a Form??? 1. what the heck is (frm as Form) in the Sub? what...

NEW: the command (next, prev record) buttons don't seem to be the issue. they were commented out and the form still won't Open from the menu OR manually. WHEN I try to manually run the form i get a message that basically says: The expression on open as the event property setting produced the...

I looked thru the help and found a way to specify how to enter a value for certain records to print in a report.. The suggestion was to use: DoCmd.OpenReport "somereport", , , "[somefieldname] = & Me.tbox (tbox is a textbox) I put in a text box, entered a value and ran the report...

Added a menu to an application and the add choice works by bringing up form1 tied to eqpt table. works. The edit choice is supposed to open the Edit form. It was created, i can make changes to it but when I click on the menu choice it brings up a Blank Form. this form is also tied to the...

THANKS AGAIN to all those who have helped me on this #@R database!! I know this can be done, but I want to do it the right way My Form has a combo box with these fields: ID 1-4, unique location: north, south, etc. (text) seqnum: Numeric/Integer loccode: (location code) N, S, E, W...

I have two tables that i am trying to put in a form. The first one works cbolocations/qrylocations, but the Equipment table does not. I added the table to the form as a query and changed the control sources for each textbox to bind the textboxes to the appropriate fields, but I cannot edit or...

Thanks to all that have helped before, I understand a little better now. On a form I have a query that updates a table eventually. That works so far, but I need to add another table to the form. Can I do that? HOW do I do that if I can? I tried putting in a record source on the form with the...

1. is a recordset nothing more than a table? 2. if i have a field called fldA in table tblA, can I/How do I store the value of that field in a VARiable??? 3. within a vb event procedure, can i close one table and immediately open another? how? 4. can i have more than one table open and...

Need help to get past this pothole in my app. I have a 1-Record Table called SEQ (sequence number table). There are 8 fields corresponding to 8 different locations and are named as SEQBI, SEQLH, SEQPL, etc. ------------------------------- The thing about this is since there are 8 locations...

I am new to this stuff so pls do your explanation accordingly. I have an access table called SEQ with fields such as SeqA, SeqB...Seq?, etc. These are Integer fields that store one sequence number for a particular location (A,B,C...). I have an optiongroup that asks for the particular...