Search results for query: *

Hello All! Maybe someone had the same problem and could help me to resolve the mistery? I created the dynamic parameter in the report, the list of values populated from Command data source. Not linked to the main data source. (like list of cities, countries). Plus i have a static parameter...

Check the default view property of the form. Probably you forgot to change it from the single form to Continuous form? Why do you think that VBA method is normal?

Change the settings for the MS Access database Menu Tools ->Optios->View tab. The box Windows in Task bar or I do for my databases to change this option on customer's computer in any start up function If Application.GetOption("ShowWindowsInTaskbar") <> 0 Then Application.SetOption...

Where you have this Dlookup? in the main form ? in the suform? =DLookUp("[PO No]","POtoLOTtbl","[Lot No] =" & [Forms]![MainForm]![SampleChemistry].Form![Lot No]) or if your Lot No is txt field =DLookUp("[PO No]","POtoLOTtbl","[Lot No] =""" & [Forms]![MainForm]![SampleChemistry].Form![Lot No]...

Hi All, I am starting to use MS Access 2003, the orginal application was created in XP version. When I insert the picture it is no longer insert it like a pictre, it inserts it like a package and I can't see the preview. :( What's wrong for 2003 and good for XP? On Error Resume Next Dim cdlg...

Strange, but nothing. I tested the code on one record all the time and when I changed another record, it was working and working with all records accept one record. I deleted it and now everything works. I am just afraid that something was really blocking the record and could happens again. So...

Hurray I am not along :) The reason for this thread was that it is not the first time in my practice, when I see unbound forms solution from programmers with many years of experience. It was strange and I thought probably something exists that I cannot see :) "Difficult to manage BeforeUpdate...

ineuw (MIS) Aug 9, 2004 wrote: Unbound forms give greater flexibility for the programmer and the user. In both cases, it's easier to evaluate the data before saving it. I can branch off to numerous public functions to evaluate and calculate prior to saving, without blocking other users' access...

interesting :) Lets think First we probably need to find out the today's day number dim i as integer dim NextDate as Date i=Weekday(Date()) ' then compare to know did we missed thursday or tuesday, right? if (i < 3) then NextDate = DateAdd("d", (3-i), Date()) end if if (i >= 5) then...

Probably... dim l as Long If CordLB.ListCount > 0 Then CordLB.SetFocus l = CordLB.ListCount CordLB.ListIndex = l-1 End If

Hi Steven, Do you have any code for making the form not visible? or closed? nothing from the code that you posted is making the form not visible

The AceMan1, :)))))))))))))) I know, I wasn't going to change it. I didn't understand your question properly. I have the table with patients and their id number is autonumber. Then I have Claims table and there SURE the id field is numeric :) This Claims table has a key with two fields...

Hi ineuw, Could you tell me why the unbound forms are more preferable for you? It is not first time when I see the solution like you use and can't understand why it is better to use unbound forms if your server and client applications created in MS Access? Regards, Aerin

Yes, it is autonumber and the message was the same " The search key was not found in any record

Help! I am completely stock on it :( I enter the data and save the record and it works fine but when I go back to the form and try to change the field (key field) - I receive this type of message :((( I was try to create an update query and change this field there...Same message, even if the...

To correct the message above, before clearing the control you need to check its type. If it is text box or combo box then clear, if not just move to the next control. '---------------------------- Private Sub CommandButton_Click() On Error Resume next Dim objControl as Control For Each...

Try Me.sfrRates.Form.RecordsetClone

Hi Amadea, If I understand you properly, you want to use one form to view the data from the table and to add new information? Is your form based on InstrName table? if you have the form showing all instructors' details and combo box where you select the instructor to view his data, I suggest...

You could create the append query, using query designer and run it when the user will click on the button Repeat. To turn off MS Access warnings use the command: docmd.SetWarning False 'run the query docmd.OpenQuery "Query Name" 'don't forget to turn warnings back docmd.SetWarnings True

write the public function(s) for defining the largest date in tables (DMax or create the recordset order by date DESC and take the very first one. DMax works slow, recordset could be not good solution for big tables and network databases)and put it to the default value property of the target...