Search results

haha.. thank u guys. vbaInet and Khalid_Afridi! both of u! ^^

it is actually used to a temporary variable (just like 'count' in a loop). use for storing userID number. :)

OMG! i got it!! i didn't define LogUser as a global variable. it works now. thanks for replying! :D

Hi all. May i know is it possible to filter records from a table using vba? I am doing a program whereby when the user type their login name and password and click "Login", the program will reference to their userID and they will be presented with their OWN records only. how do i filter off...

it somehow works.. but now appears the "Enter Parameter Value" for LogUser.. How do i get rid of that message box?

ok. i have just edited my codes. here is it. Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim strSelect As String Set db = CurrentDb Set qdf = db.QueryDefs("userFilter") strSelect = "SELECT UserSettings.[UserID] FROM UserSettings WHERE UserSettings.[UserID]='" & LogUser & "';" qdf.SQL =...

i did it.. but when i run the program, it states "runtime error '2001' you cancelled the previous operation".. :(

how do i create a query in VBA n run it den? i did this.. Dim Query As String Query = "SELECT Clients.UserID FROM Clients WHERE Clients.Location = 'East' ORDER BY Clients.UserID;" DoCmd.RunSQL Query but it states a run-time error. "RunSQL action requires an argument consisting of an SQL...

Hi! Anyone here knows how to filter a table record using VBA? For example, I have a list of customers. I want to filter them to those living in the East only. How do i do it using VBA code? Please reply.. Really need help here. Thanks!

what is a recordset? can show me an example? thank u!

how come when i call a field (table.field) from a table in a form, it states "compile error. variable not defined"? eg: pressure = importedTb.pressure it highlights the importedTB. must i declare the table in that form first before i can use the table? how do i reference the table (if i...

can u show me an example on how do i import the table then append the query pls? because when i: data = DoCmd.TransferText acImportDelim, it says syntax error. thanks n regards!

can i insert a imported file (using DoCmd.TransferText acImportDelim) which got 2 fields to the following function? SQL = "INSERT INTO Table ( field1, field2, field3, field4 ) SELECT '" & LogUser & "' AS x1, #" & Now() & "# as x2;"

but what if my raw data has only 2 fields? what shld i do to add to the existing fields in the table?

hi! may i know how do i inport a text file (.txt) to ms access? i want the text file data to append to the existing fields in my ms access database. eg, in my ms access, i got a table (Settings) with 3 fields: name, duration, pressure in my txt file, i got 2 data: 20 <tab> 10 may i know how...

actually i m creating a database where there is a form for new users register their particulars (which store inside a table). after that, he/she can log in via another form and view his/her own individual status / preferences / settings (example, a record of all of his/her login dates, change...

thank you, McSwifty! :) ur codes really helps! but may i know is it possible to store all the dates in which that particular user has login into the database throughout (like a period of 1 year) instead of being overwrite each time he/she log in?

hi! can u give me a sample of ur above database if possible? sorry for the trouble! n i would like to ask.. where the above codes are placed?

no reply? :(

hi! please be patient with me. i am only a newbie in ms access. may i know how can i go about keeping a record of the dates for each user who login to that form? i have already created a table of users who can login and password. now i need to track each user's login dates. how do i do that...