Search results

Its quicker & easier to use the dlookup() function in your case Private Sub cmdOK_Click() If dlookup("count(*)","UserT","password= '" & CStr(textpw) & "'") = 0 then MsgBox "Sorry, Your Password is incorrect." Else DoCmd.Close acForm, "PasswordaddF", acNosave DoCmd.OpenForm...

Before going into the details of your code, I spotted the following cause for errors: wb = "F:\MyDoc\Weekly MI Automation\" & sTeamRegionName & Left(Date, 2) & Mid(Date, 4, 2) & Right(Date, 4) & "_" & Left(Time, 2) & Mid(Time, 4, 2) & ".xlsx" Left, Mid & Right are used for string operations...

Not sure this function would return anything though :p

Internet cookie??? If I ever come down to Johannesburg you're buying me a beer! haha Glad I could :)

Something like this? Dim i As Integer, iPrevious As Integer, strNames As String, tempName As String, UC As Integer, LineNum As String, Qstn As String, AF As String, PP As String, pubD As String, CycleNum As Integer, Dassign As String, suspDate As String, Crit As Integer, assignby As String, tb...

Great! Make it a habit to not use spaces in names.

Post up man, we love database issues! What's troubling you?

Tell me about it, I studied Mechanical Engineering but always worked on DB development on the side. Got a soft spot for it. You're gonna love it. The best thing you can do now to debug, is to debug.print your sql statement in the immediate window to see how it looks like. Debug.print "INSERT...

You missed a few & sign here: tempName & "', CycleNum,

Pop a cold beer open brother, it's going to be a long night haha

If you insist: maxNumber = DLookup("max(mid(codes,3))", "table3") + 1

Yes, here's more on how INSERT INTO works http://www.w3schools.com/sql/sql_insert.asp

Well now that you have more than one field, you're going to have to mention to which field every piece of data goes "INSERT INTO tblActiveMaster(field1,field2,field3) Values ('" & tempName & "'," & UC & "," & LineNum & ")" Remember, strings need to be wrapped with single quotes and dates have...

Welcome! You'll get all the support you need on here. Please don't ask for our bank account numbers to transfer inherited money though haha

Only if you're moving other data along with the Names

Do you just want to do a one time import? Or do you want to have the excel sheet linked to your table so that changes in your excel sheet are reflected in your access table? I recommend against the latter, unless you have no control over it. Both can be done from the External Data tab =>...

Yeah I'm sorry I lead you into a longer route with the whole array business. After I started working on it I figured there was an even easier way, which was the one I posted. You just need to replace "column6" and table1 & table2 with your actual field and table names that's all :)

If you have a male entering his number of pregnancies then you have a bigger problem :D

First you have to link form to a table => Use record source property of the form Then you link your fields using the fields control source

Can you share the DB with us to troubleshoot it?