Search results for query: *

My current form allows edits to a record. I have a contol button activating a POP-UP form (where Popup=Yes and Modal=Yes) to edit Void fields in the same record. How do I get around the 'Another User Updated Record' after editing in the POP-UP then leaving both forms ? Refresh, Requery in...

Since you are importing into an existing table, add one more field at the end for file name (FileName). The import should leave the field null. Then RunSQL that will put the file name in the table where it's null. DoCmd.TransferText acImportDelim,"EVAL","EVAL","D:\CNew\"& strfile,True...

Well if you save the variable value in an Access table, you can open the table as a recordset in Excel VBA.

If you are displaying this message in an Access Form then set Form Property PopUp (under Other) to Yes -and- Form Property Modal (under Other) to Yes The Form takes over and nothing can be done until it is closed.

Use this function to find the last blank ... Function LastOccurrence(strSearchString As String, _ strLastOccurrence As String) As Integer Dim intVal As Integer, intLastPos As Integer intVal = InStr(strSearchString, strLastOccurrence) 'Find 1st Do Until intVal = 0...

=Format(Date()-Day(Date()),"mmm-yyyy") 'yields last day of prior month -or- =Format(DateSerial(Year(Date()),Month(Date())-1,Day(Date()),"mmm-yyyy") 'yields 1st day of prior month

Something like this ... [code]cboProductID.RecordSource="Select field1,field2 " & _ " From tableofCustomerRequirements Where CustomerID=" & _ [Forms]!

Bravo MMoran! Both are well written and comprehensive. HGE

I've been a consultant since '93. I believe there is a tremendous need for 'hybrid' type programmers. That is, people expert at building Applications and who also know the business side. I use Access and am knowledgeable in both Auto Parts Distribution/Sales, and Drug Distribution/Finance. The...

For a Text Field -> Where [Product No] = '" & [Product No].Value & "'" For a Numeric Field (don't use single quotes)-> Where [Product No] = " & [Product No].Value

The definitive answer is ... A Public Variable declared in one Form is not recognized in another Form. Declare your Public Variable in a MODULE (I call the Module PUBLIC) and all Forms will see it !!!