Search results

  1. H

    Solved Addition not working in a Query

    Hi There, I am trying to understand what I am doing wrong with the attached Query. I extract and calculate a number of fields from two tables. When I multiply one field by another it works perfectly. See field "CubeCost" However when I try to add a number of fields the result is that the fields...
  2. H

    Solved Query based on combo box

    I am having a mental blank I am trying to pull payroll records in a query based on a popup form that asks the user to enter StartDate, EndDate and EmployeeName The employee field on the form is based on a combo box tied to the employee file which brings back fields EmpID and Employee Name As...
  3. H

    Solved Using DLookup in an access query

    Hi There I seem to be unable to do a DLookup in a query. I have a separate database to the one shown and was experimenting on using DLookup in a query. Unfortunately it failed with a message "Undefined function 'DlookUp' in expression" This has had me stumped for a few days after checking...
  4. H

    User Defined Function help please

    Hi There, I am trying to clean up repetitive code in an application I wrote many years ago. So far this process has been working well for reducing repetitive code volume and making the application easier to maintain. But I am having trouble with the attached Subroutines that I would like to...
  5. H

    How to determine size of tables, forms etc in Front End database

    G'day, I have built a multiuser, database over many years and split it into Front-end and Back end data bases. The backend is currently 68Kb and the front end is 220KB. I have compacted both Front end and back end databases weekly and it is stable. However I think the front end should...
  6. H

    Navigation pane format (SOLVED)

    I'm not sure why but entries in my Navigation pane seem to have double or triple line spacing as per attached. What do I need to do to reset same to single line spacing or reduce the size of the font so that I can get more lines of tables, queries etc in the Navigation pane? I assume this is a...
  7. H

    Running out of Memory Errors ....

    G'day, I recently replaced my old DELL pc with a new one with 16gb of Memory and 512Gb of Solid state drive. I have effectively doubled the capacity of the old PC in both memory size and SSD storage. I am running Office 365 / 64 bit and Access 2016. Error seems to occur when editing or...
  8. H

    Removing a table relationship

    G'day, I had a relationship between my Employee file and another 1-Many file (tblJobTitle) in my relationship diagram. So when I open the Employee file I have records with a plus (+) sign on them. When I click the + on one of the records I can see the related tblJobTitle records. After some...
  9. H

    problems with Win 10 & Office 365

    G'day, I have just upgrade to Windows 10 and office 365 due to the old system dying. I am experiencing lots of bugs coming to grips with the new Access. One annoying bug is that if I want to specify a string like "tblEmps" I do not see the first set of rabbit ears as I data enter the double...
  10. H

    Employee Table

    Hi There, Many years ago I developed and I am still running a basic payroll system, At the present moment I have all the standard employee data fields and the system has been running well for many years. However I have a question, currently each year we hire several new hires and over the years...
  11. H

    split forms

    G'day, I have created a split form using the access 2010 standard form creation wizard and it seems to work ok except that the database form is too wide. The data entry form is ok. I have been fooling with it for quite a few hours without much success. If I try to edit the form it shows me the...
  12. H

    Can yourefresh a table in Query Design view

    G'day, I have created a query in query design view and it works ok on the two tables I am using. I have now added an extra field to one of the two tables (tblVehicle). If I drag a new copy of the table into the existing query in design view it is now called (tblVehicle1). Examination of same...
  13. H

    Bill Of Materials

    G'day I am not sure where to log this request. :confused: I have 3 tables. a table of customer orders A table of preconfigured Assemblies with a bill of materials (or Components) A table of components which can be ordered individually and they may also be part of an preconfigured assembly...
  14. H

    Mouse events on a form

    G'day, I am in need of some help please. I have a parts order form (FrmORDER)with a list of parts selected stored in it. e.g Part #, Part Description, Qty, Price etc I also have assemblies stored with the same detail that are composed of individual parts. What I would like to do is open...
  15. H

    Updating sort order of records

    G'day, I have a table with entries describing a sequence of Tasks (tblTask) tskID TaskDescription 10 Clean Room 12 Wash Dishes etc I have second table called Steps (tblSteps) that is related to tblTask via the field "StepNumber" which is a concatenation of [tskID] & "." & [StepOrder] So if we...
  16. H

    Problem with Subform not updating

    G'day, I have a dbase with 5 tables N_Customers, N_Orders, N_Products, N_Timequoted and Employees. I am trying to build a form showing Customer Name, a subform1 with list of Orders and then for each order a subform "Products" with the list of the parts used and finally subform3 "Labour" with the...
  17. H

    Run-Time Error 2105

    G'day, I am running access 2007 in Win7. I have a time sheet application that I wrote many years ago. Within same I have a button to press to open a new form to enter time sheet data. The data for the form comes from a query that links Employee and the Timesheet history data file. In an effort...
  18. H

    Cannot use ODBC to import from, export to, or link to an external Microsoft Access o

    G'day, I am trying to create an ODBC link to a copy of the Northwind data base. I am running Win7 on a 64 bit operating system but am keeping office running as 32 bit for Access, Excel , Visio etc due to the fact that I have a lot of old apps tied to them. When I attempted initially to...
  19. H

    How to vary field widths in a default SPLIT form

    G'day, I am running Access 2003 and have created a split form using one of the std form options. The file it is querying has about 20 fields per record. The split form that is generated has four columns of 10 fields each. e.g. Column 1 Column 2 Column 3 Column 4 Employee Fred Smith...
  20. H

    Trying to get a form to requery data specified prior to opening

    Hi There , I am a newbie to this forum. I have a main form "FrmTimesheetEdit" that I open in edit mode to review data in a query that uses two tables TblEmployee and TblTimeSheet. The TblEmployee has two fields called EmployeeID, and Employee. The Tbltimesheet table has a field "Weekendingdate"...
Top Bottom