Search results

Hi All, I'm making a program that displays database entries between 2 dates in a graph form. I want a new graph entry for every day even if there is no data on that day. for example, If a set the date range to: 08/01/17 to 12/01/17 and I have 2 records between those dates on the 8th and the...

Hi All, I have a split database with a frontend that I semi-regularly update (when one of my users finds a bug I never would have thought for looking for). On my menu screen i have a text box that says: "Last Updated: ##/##/####". At the moment I manually update the date every time I update...

Hi All, I'm trying to make a form that shows what the last record was next to the empty space where you enter a new record. This is so the user knows that what they are entering is roughly in line with what has come before. So for example if I was recording temperature every May, I would like...

Hi All, I have 2 tables that have a one to many relationship between them. Table 1 is the details table (this information never needs to change) and Table 2 is the records table (a new record will be created every year). So for example: TABLE 1 ID ¦ Item ¦ Brand ¦ Units ¦ Model ¦ Serial 1...

Hi All, I'm changing a record source on a form when the user clicks a "save" button. I'm doing this to store a value from the current form in a table that is not part of the default form query. This works fine. I have a separate button on my form called "Home", when the user clicks this...

Hi All, This is simple task but I can't get my head round it. I'm incrementing a counter every time I click on a combobox by using the on click event and this code: POcount = POcount + 1 I have 5 fields on my form: GWS1, GWS2, GWS3, GWS4 and GWS5. I want to store the value of the combobox...

Hi All, This seems simple but I just can’t work it out. I have a form called “new jobs form” populated by a query called “New Jobs query” This saves data in a table called “jobs”. I have 5 fields in the “jobs” table called: “Purchase order number 1” “Purchase order...

Hi All, I have a form that is maximized to fill the screen which has a black background, This form contains a white square in the middle of the screen which contains all the controls. The last control I have at the very bottom of the white square is a combo box. When the combo box drops down...

Hi All, I'm trying to add hidden information to a record and need to know the best way to do it. I have a visible table that all users enter data into using a form. I also have a hidden table that contains 2 fields "linked Table ID" and "notes" I have a box at the top right of my form which...

Hi All, I have a database with a large number of records: ~2000, so I use a form in datasheet view to filter and sort the records to find a particular one. This works fine for locating a certain record. Sometimes I then need to make a new record but I will be duplicating a few fields from the...

Hi All, I have a form created from a table that contains item information. I have a sub form linked to a different table that contains records. Each item has multiple records associated with it, so for example 1 record on the main form could have 10 records displayed in the sub form...

Hi All, I'm making a database that so I can log calibration information about equipment every year. I have 2 tables: The Equipment details table The Calibration record table ID Number is shared between the 2 tables so a calibration record can be linked to its' details. For Example...

Hi All, I have a form that contains a combo box, I used the access wizard to make this combo box select a record from a table of customers and display that record on the form. The user then has the option to print that record. This works fine. I now want to be able use the same combo box but...

Hi All, I'm using access 2003, I have a split database with the back end on a remote PC and seperate front ends on 4 other PCs in my office. I'm making regular changes to front end (adding features, fixing bugs) so want everyone in the office to be using the latest version of the front end...

Hi all, I'm using access 2003 I'm using a bit of VBA code to save reports as PDF files that I got from this website http://www.lebans.com/reporttopdf.htm This has been working great but I've noticed that if I've already saved my access record once then I make a change and re save that the...

Hi All, How do I remove items from a right click menu in access 2003? For example I need to remove the form view / design view button from a right click menu but i want to keep the hide/show columns button on the same menu. any ideas?

Hi All, I have a form that i used the following code on to stop people accessing anything naughty: Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next iThis works great and gets rid of all the menu bars. The problem is that it also stops the user getting the...

Hi All, I'm trying to write a query to allow the user to search through records. To make the interface simple I just want a combobox to select the search field and a text box to enter the search string. My problem is trying to build a query where the value of a combobox on a form is used as a...

Hi All, I have the following code to export a query into a excel file: Dim outputFileName As String outputFileName = "C:\AccountSpreadsheet\test.xls" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Q_Search_Invoices", outputFileName, True Dim xlApp As Object Set xlApp =...

Hi All, I have a series of records that I would like organised into groups. For example everyone with the surname Jones who lives in Wales and is between 18-30 years old. I would like a Combobox that has that group sorting visible in some way, possibly with colours. for Example if i had the...