Search results

Hi - I have local tables that needs to be updated based from another file. To update the data of the local table I usually do this strSQL = "Insert Into tbl_holidays Select * From [MS Access;DATABASE=" & pathofanotheraccessdatabase & ";pwd=" & thePwd & "].[tbl_holidays]" CurrentDb.execute...

Good day, I'm not even sure if I have the correct term for my post TITLE but I will try to explain it further. 1. When I am trying to copy a record in a table and insert it into a new table(another database) what I usually do is this: Dim db as database Dim strSQL as string Set db = currentdb...

Hi Good Day, I need to add hours to a given date and time but the condition is it needs to skip the weekends ,holidays and, non working hours. Example: Shift Start: 08:00 AM Shift End: 5:00 PM Add 3 hours to 10/7/2016 3:30:00 PM The result should be 10/10/2016 9:30:00 AM...

Solved:Calculate Time Elapsed but exclude Non-Working Hours Good Day! I have a start date and time (06/16/2016 12:52:01 AM) and an end date and time (06/23/2016 12:52:01 PM), I need to calculate the time elapsed between this two but it should only include the working hours which is from 8:00...

I have a table linked to a backend database that is the recordsource of a subform. The problem is latency issue because of multiple users. I want to use ADO to update the record in the subform instead of linking it. I just want to get your opinion which is the best option... I have think of two...

Hi - First off, I know how to connect a front end to a back end using linked table. I was reading about connection string .I just want to get some insights. If I have a subform in my front end how do I get the data from the backend. because in a regular subform what I would normally do is...

Hi - Is there a way to hide the border of the MS access window? I just want to hide the border nothing more. Thank you Hudas

Hi , I have the below SQL statement... In table2 there is another field called timestamp1... Is it possible to have the timestamp1 included in the below statement so that I will have a record of time the moment the records were inserted in table2? There is no timestamp1 field in table1...

Hello! I need help!.. I have an unbound mainform and an unbound subform(datasheet). The source of the subform is a query which is dynamic(I have many queries with diffrent columns). the subform source is change using a combo box selection. I have text boxes in my mainform... my question is how...

Good day! I need help in creating a query: I have a table with three columns the ID(PK), Date, BatchNumber. In the BatchNumber column there are entries like HP, MP, LP. What I need is to get a random sample of 10% of the population. But random samples should have priority based on the HP...

Hi - I have a query: the first one shows the number of emails received for each date SELECT tbl_rEceived_eMail.ReceivedDate, Count(tbl_rEceived_eMail.EmailID) AS EmailCount FROM tbl_rEceived_eMail GROUP BY tbl_rEceived_eMail.ReceivedDate; The second one shows the number of emails received...

Hi Everyone, I am hoping someone could help me with my problem because I'm completely stuck. I've search the web but I can't find the answer. So here it goes... I have table with [EmployeeName] and [DateReceived] column what I am hoping to accomplish is to get 5 samples of each Employee for...

Good day!! I am hoping someone could help me out with my problem... I have two table - TABLE 1 contains letter of the alphabet and a user assigned to each letter while TABLE 2 contains company name and user assigned to each company. What I'm hoping is if I change the user2 for letter A in...

i I have two queries.. What i'm hoping is to combine the result into one query but not in one column only but instead the result of the second query should be beside the first query.. The result of the second query should be added as a new column. First Query SELECT tbl_uSers.UserName...

DLOOK UP Error "The MS Office Access database engine cannot find the input table etc. Hi - I have multiple database opened I have a macro in outlook linked to ms access... I have a DLookup that looks up the name of the assigned agent based on the table vendor assignment using the sender email...

Hi - I was browsing the Northwind database and notice that there is a dropdown in the table(Kindly see attached print screen). I've been trying to recreate it but I'm having a hard time. Can someone help me out or provide a clue as how it can be done? Thank you Jun

Hi Everyone... I have to search the Filename field and return the value on HelpDeskNamefield on the Table1. The problem is the data on the Filename field contains only a portion of the value that I am searching. For example... I have 'majdatlate' that I need to search but the data on the...

Hi! Everyday I have to generate a report in excel format and I need it to be added to ms access database. I was hoping to do this on a click of a button. Basically, since i have a new data everyday it should be added to the table. Can anyone please point me out the the right direction or maybe...

Hello! Whenever a user opens the form then vba gets the user login and add it in the combo box row source, with this the user can only access his/her record. My problem is there are users that needs to be given access to other agents record. So what I am hoping is whenever the user opens the...

Hi - I need help,i have a textbox that I put in minutes as whole number. What i want is to put in AfterUpdate Event to convert that whole number to hh:mm.... Thank you Hudas