Search results

Hi all, I have a table called Customers and one called Notes. The Customer has a CustomerID. This is the fk in the Notes table. The Notes fields include NoteDate and Note (which is a memo field). I need a query which will display the data as follows: CustomerID | NoteDate1 | Note1 | NoteDate2 |...

Hi, Most of my users use Access 2003 and there are no problems with it but one user has Access 2002 and when he goes to open a form thats already open it crashes the database. Basically I have a continuous form with a list of instruments and when the user clicks on the button beside one it...

Basically I have a secured split database. Each user has a copy of the FE on their local drive and the BE is on the server. I have 2 main user groups: FinanceUsers and purchasingUsers Both groups of users edit data directly in the invoice table ( believe me it was not my idea - I am slowly...

Hi, This is the source of the combo box: SELECT M_RequisitionOrders.ReqOrderID, M_RequisitionOrders.FieldReqNo, M_RequisitionOrders.OrderDescription FROM M_RequisitionOrders ORDER BY M_RequisitionOrders.FieldReqNo; The bound column is the first one. However, I would like users to be able to...

Hi, I am trying to put 2 columns in a report as in the attached word doc. Its not working tho - the second one just appears below the first one. Here are the settings I've applied: I went to page setup and changed the number of columns to 2 and the width of each column to 11cm.The total...

Hi, I'm having problems getting my head around the best way to design a table for an employees expenses. This is my current M_Expenses table: ExpenseID (PK) PayrateID ExpenseType Amount PayrateID is the foreign key to a table that holds information about their rates, evertime etc. My idea...

Hi everyone, This post will probally turn into a rant about my workplace more than anything else. I'm having lots of problems trying to estimate how long it will take to do parts of my project. The project has to do with payroll - there are about 450 employees all over the world - some being...

Hi, I have a folder for each of 80 employees. The folder name is made up of the employees name and employee number e.g. Aldea, Robert 34 In each folder are timesheet files for that employee. Basically I need the code to find the correct employee folder and list the files in it. I have seen...

Hi, Here is my code: WeekEndDate = CDate(Format(InputBox("Please enter the weekend date.", "Enter weekend date"), "long date")) Set qdefPayReport = CurrentDb.QueryDefs("UnionPayCyclesAll") qdefPayReport.Parameters("Weekend") = WeekEndDate Set rsPayreport =...

Hi, I have an unbound form for importing employee hours from a spreadsheet. There is an unbound textbox on it so that the user can enter the week ending date. The user enters the date and clicks on the Import button. An sql statement is executed to add the employee numbers, hours worked etc...

Hi, I'm building a database for HR in my company - the idea is to produce a report to show what is being paid out by payroll. There are 3 pay cycles - weekly, bi-weekly and monthly. The report will be grouped by the into these 3 categories. I have created the report that does this for the...

Hi, I would like to get your advice on my table setup and relationships for this payroll project. The company is an engineering company with Projects (or construction sites) around the world. The 'Candidates' are current or potential employees and contractors. There are three main pay...

Ok, Bacically I have 2 different lists (well there will be 7 in total): tblValves ValveID KKS_no Description List - specifies thats its in the valves list TOP_Code tblSpools (pipe sections) SpoolID SpoolTagNo Description List - specifies thats its in the spools list TOP_Code The reason that I...

There are 3 main tables tblDrawingRegister - stores information about construction drawings tblDrawing Revisions - each drawing in tblDrawingRegister has one or more revision or version tblVendorDrawingList - this table has a list of drawings numbers that correspond to the drawings in...

Hi, I have the following code in a module - Im creating a recordset in ADO. The sql code is fine - I've tested it in a query but I'm getting the "Jet cannot find your query or table" error. This is because the sql refers to two other queries:NewestTransmittal and LatestRevTransmitted. How can...

Hi, I have two tables: tblOutTransmittals and tblTransmittedDocs. A document is sent with a transmittal document which the recipient signs to confirm that they received it. I've created a query that will show all the drawings/documents and the information about the associated transmittals. What...

Hi, Am having a very strange problem: The ErrorHandler does not get executed. There must be a mistake in the code but I'm not seeing it! Here is a pared down version of my code: Public Function createAssignRecord(lstPart As ListBox) On Error GoTo Err_createAssignRecord Error 3022...

Hi, I have read that it is important to close any objects and de-reference them in order to prevent corruption. Here is some code that may have caused problems in my database (I've only just added the last line). Could someone check it to see if I've closed and defererenced everything I should...

Hi, With my database I have actually distributed the mdb file to 2 of my users so that they can make their own reports. I have secured it so that these users cannot delete/modify anything they shouldn't. However every so often it seems to get corrupt. I did decompile it and I tried importing...

Compact an MDE file through DAO Hi everyone, I've figured out the best way for me to compact my database from the posts here but I have a small problem with it. My backend end is an MDE file (have no idea why I did that now) and the code I have doesn't seem to work with MDE files. Dim RS As...