Search results

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...

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!

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 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;"

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...

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...

hey guys. i have a encountered a problem. i have a form, which open a new record for users to enter their particulars. their particulars are all stored in a table. but i do not want them to see or edit other previous records entered by previous users when the form is open, they can only...