Search results

Hello All, I'm trying to find out if a record exists in a table. I have searched and found several methods, but I have not been successfull in making any of them work. Here is how I want to implement it; I want to check in a log table to see if an archive has been made for a paticular month...

I firgured it out, I had to play with source and destination (its quite confusing, at least to me). Here is the working code: DoCmd.TransferDatabase acExport, "Microsoft Access", dbDest, acTable, tblname, tblname Rick

Hello All, I am trying to export a table from one database to another, to be used as an archive. I have tried to use the TransferDatabase method but keep coming up with an error: runtime error '2006' The object name 'C:\Program Files\Commission_Database\Backup\Backup.mdb"you entered does not...

Yes. Thru a form the user selects the start of the week then the append query runs. Currently I have an update query running that fills in separate fields for Monday thru Friday. What I would like to do is have a single field with Monday thru Fridays dates added to it. [This message has been...

Hello Everyone, I'm trying to append a weekly set of records to a table. The current append query adds one record, the StartDate, which works outstanding (Many thanks to DavidR for the help on that). Here is the SQL for that: INSERT INTO tblWeeklyInput ( EmployeeID, StartDate ) SELECT...

David, Thanks for pointing me in the right direction, I tweaked the query and came up with this: INSERT INTO tblWeeklyInput ( EmployeeID, StartDate ) SELECT tblEmployee.EmployeeID, [Forms]![frmsetup]![StartDate] FROM tblEmployee LEFT JOIN tblWeeklyInput ON tblEmployee.EmployeeID =...

David, That works so much better when you put it there! LOL Now how would I referance the employee table to get all of my employees? Right now insert into query only uses the employees that are currently in the WeeklyInput table. Which is fine for now, but wont be when employes change, either...

David, I think I understand, your quite good as an instructor! Now this is the part where I'm the bonehead student: I made a test form, made a button, and at the On Click event I make an event procedure. I put the following in: Private Sub Command4_Click() INSERT INTO...

Thanks for the reply David. First I must admit that I don't know much codeing, with that said; I see the first part as being a button with error checking to make sure something is inputed. Then Im a bit lost thru the next part of the code, I dont understand what its doing so I dont know how...

Thank you both so much for your help, I have that portion up and running now. Rick

Hello All, I have a database where the user enters the hours an employee had worked that week. The number is later used to figure if an employee gets an overtime commission and if so how much. ( a bunch of Chinese arithmetic the IRS dreamed up). Commission changes every quarter hour, so at...

Hello Everyone, I have a time sheet DB that adds up daily totals for a weekly commission. To do this I have set up three tables to handle this: EmploeeTable: EmployeeID Lname Fname Payrate CommTable: HoursWorked CommissionRate WeeklyInput: WeeklyInputID EmployeeID StartDate Mon Tue Wed Thu...

Hello All, I've done up a report, and when I go to preview it, there are 3 pages, exact copies of my one report (I have only made one in the report design). I have checked to make sure my page set up is not extended past the 8.5 X 11 standard (and its not white space I get), searched every...

I have an Excel spread sheet that does calculations for commision. I use a look up table to compare how many hours of overtime a person works and gives me back a value. For example, a person works 41 hours, the multipler for that is 0.012. I am moving this and other calculations to Access. I...