Search results

How about isnumeric validation...? This may solve the problem just an ideal not sure if it applies to your train of thought.... Regards,

Personal Experience.... I work in a retail company. I have developed over time good filing methods for the users / executives. I put shortcuts on their desktops for easy access. File things accordin to fiscal years / periods in appropriately assigned directories... I personally would spend time...

Do you know VBA? .

This would work... Select Top 1 tblXXX.* From tblXXX Order By tblXXX.ID Desc; .. or Asc; I always mix the 2 up... :) Hope this helps....

This what you want...? Sub cmdOpenForm() VReply = InputBox("Enter your string here?", "I love my dialog box.") If NOT(VReply = "") Then DoCmd.Close Open_form(VReply) Else MsgBox "You must enter Value", vbOKOnly, "Input Error" Exit Sub End If End...

Personally... I would build a parameter query that would concatenate all the fields together exactly as you stated, prompting for a filter ID or unique ID and this would give you a response without care for the results length... There after, export the query to a .txt file in a Macro...

Well here's my view... You have the ContactID. This need to be stored in the other table as a reference.... When reporting or querying later the relationship to the contactID will give you all the info on the contact. tblContact fldContactID fldContactName fldContacPhoneNo fldContactAddress...

2 ways.... Hey bud... 2 ways, I'll give you easiest. tblNewField(0) = Var1 & "-" & Var2 or tblNewField(0) = txtVar1 & "-" & txtVar2 This is my preferred tool of choice using the: Left() Right() and Mid() Functions... Hope this helps.... Regards,

Ok, well here's the good code... Just re-name your find button... Function Find(vTable As String, vField As String, vSearch As String) Dim db As Database Dim rs As DAO.Recordset Dim strCriteria As String Set db = CurrentDb() Set rs = db.OpenRecordset(vTable, dbOpenDynaset) ' This function...

Jimee Well I was searching for a long in the index field.... If you are searching for a string you must pass a string.... Function Find(vTable As String, vField As String, vSearch As String) Dim db As Database Dim rs As DAO.Recordset Dim strCriteria As String Set db = CurrentDb() Set rs =...

Function Find(vTable As String, vField As String, vSearch As Long) Dim db As Database Dim rs As DAO.Recordset Dim strCriteria As String Set db = CurrentDb() Set rs = db.OpenRecordset(vTable, dbOpenDynaset) ' This function will allow to search diferent fields... strCriteria = vSearch If rs.EOF...

Correct me if I am wrong... You need to store the value of the index you are refering into the combo box assign it to the other form when opening it... Such as... Function Open_form(Form As String, vSearch As String) On Error GoTo Err_Open_form Dim stDocName As String Dim...

Whoa... Don't know about anyone else, but bud I think we need you to ellaborate. What table, and are you refering to the index like autonumber... A field like a name... Give us some more details bud... Regards, Brian

Personally... I would hard code it in VBA. You search on the find 'table' as a variable and you call this function passing the parameter of the table name. I use such a function regularly. I do not search multiple tables, but alas a loop calling this function and sending a user replies for each...

My Approach... I use the Left(Var,2) & "- or / or :" & Mid(Var,3,2) & "- or / or :" & Right(Var,2)... I format dates and time like this because I work with many systems that do not use the same formats. So I code the formats in a string and feed which ever system the way it wants it.... But...

Search for arrays in the forum, I found it before can't locate my coding right now, but I was able to reference text boxes through arrays 'variables' sorry I can't give a better answer right now busy.. :) Regards, Brian

,

Hi This should work Where Right([tblxx].[Grade],2) IN ("80", "60", "40", "20", "00") Regards,

Listen up... This works, but worries me. If anyone understands this please let me know if it is normal and / or ok..? Query: TRANSFORM Sum([tblOPOP].[Qty]) AS data SELECT [tblOPOP].[Div], [tblOPOP].[Code] FROM tblOPOP WHERE Mid([tblOPOP].[Period],3,4) Between "0349" and "0352" GROUP BY...

Sorry... I do not code with types, and haven't since C++ in school.. :) We will need someone elses feedback. Also would help to see when you assign your variables, such as when they log in? When you assign them to the table... Although you would only require the user ID for further referencing...