Hi, I have multiple user login based access database. There is table with name""UsersActivity". I created a form based on this table. I want to highlight users whose status is still logged in but not logged out yet from the the database. There are three fields in form (taken from table), and a...
Yesterday you provided the SQL select id, invoice, dcount("1", "yourTableName", "ID <= " & [ID]) As Sequence, Status from yourTableName Order By id Asc;
I do not have an ID value. To simplify, assume a table of only invoice numbers with duplicates. How would I change your SQL to:
1) get a sequential number for each record
2) get a subset of sequential numbers by the invoice number
Hello, In this form browse button VBA code is string and instant successfully in the path box. But problem is file not exists as same name. where import table field are same. It was instant between name LIKE filename._xlsx1, filename_xlsx2,. I want to import table append copy in same table...
Hi all... I am developing my first access app for building construction work purpose Actually all I want is to make monthly progress reports to submit to my boss This is my masterTable Project Name | Locality | EstimatedCost | Stage1CompletedDate | Stage2CompletedDate | Stage3Date | etc...
Hi Everybody, I am new in this forum. I am learning VBA programming for Excel and Access. Would like to upgrade myself with the vast knowledge base available in this forum. In profession, I am a Mechanical / Piping Engineer, living in Thane, Maharashtra, India.
I'm new to this forum and just joined today. I am an Access Developer for our local Food Shelf, but I am not a programmer and usually need help to use SQL. I taught myself the Access from online videos and chats. Hopefully I won't need to much additional help, but it's nice to know that this site is available. Thank you,
hello .. hope you are fine
i need to make a list box field in an access table its value depends on the value of another list box >>
Example a field2 is a list box its values appears depends on the value i chosen from field1 list box ,, so
i made a table for field1 values and another table for values of each value in field1
how could i control it
Hi, I am reaching out to you because of your Export to Excel with Conditional Formatting post. I am having a hard time tracking it all but I see that you got it working i have been searching for this answer for a while can I see your finishing code I cannot seem to figure this one out please help!