Search results

Hi Accessers! I have an Excel workbook that has 36 sheets which each hold information on teams entering competitions. Data from each sheet is collated on a single sheet, then transferred into Access for sorting by using a series of queries to further sort the information. The sorted data is then...

Hi Accessers! I've created several Split forms that have the data input fields in the form with the relevant query datasheet shown below. As you tab through the form fields, the various cells in the datasheet are highlighted and move across the data row (as one would expect!). I want to put a...

I've got a bit of a problem with linking a text box to a ComboBox. I have an employee name in a field [EmployeeName] that sits in the Header of a Form. (This is so I can show multiple records for that employee without having their name repeated at each one). I also have the name of contact...

Not sure if this can be done, but here goes... Having built a database that tracks projects across their lives, I've now been asked it I can identify the latest status of the project in a "quick view" The table "All Projects" has columns that list the Project Number; Project Title; Project...

I have a "Date Select" form that is linked directly to a table that only has one column in it, "Dates". The column in the table is a Date/Time column and is sorted in date order, Lowest to Highest, and when any new dates are added to the table (through another form) they re-sort into date order...

Still new to VB / VBA and trying to create a code that will export data from a query into Excel. I managed to get that far, but the process ended with a "Type Mismatch" message and the data not always transferring, (it should overwrite the previous export) Looking at the Excel spreadsheet there...

Bit of a problem here that I can't seem to find an answer to anywhere. I've started with a Listbox in a Form from a Table of meeting dates from which I highlight a date ane try to recall information about the meeting (past or proposed) from the main table by clicking on a button which in turn...

I'm still very new to this game and have been searching the Internet for bits and peices that I then build into something that generally works! I'm now attempting to use a button on a form to open a sub-folder that is held in My Documents folder, "Customers". The Sub-folder name is that of the...

Hi Accessers! Another little thing that is driving me insane and that I can't find an answer to on the forum or through Google! I have a process that lifts a highlighted date from a List Box and puts it in the Criteria of a query. The process manages to move the numbers from one place to...

Hi Accessers! I've got a code that allows me to select one or many names from a listbox on a form and return data relevant to the name(s) selected from a query. The following code is triggered by a button on the form... Private Sub Toggle4_Click() 'Set it all up for CSM selection Dim db...

Hi Accessers! I have a database that is used (partially) to enter appointments during a day. In the appointment column I've entered the date and time as dd-mmm-yyy-hh-nn-ss. I'm now trying to search for appointments entered on a specific day through a user input ([Enter Date] in the query...