Search results

Hi, I have the following duplicate check query that is returning inaccurate results: SELECT * FROM tblListDetails WHERE (((tblListDetails.record_id) In (SELECT [record_id] FROM [tblListDetails] As Tmp GROUP BY [record_id] HAVING Count(*)>1 )) AND ((tblListDetails.list_id)=24)); Below are the...

Hi all, I've been trying to search for a solution to this problem, but can't even find any posts by others with this problem. On some forms I use a tab control with the Style as None so there are no visible tabs or buttons. This way I can re-purpose the form for several different functions...

Hi, I am designing a contact database for a diocese and the contacts record form is divided into several tabs, some of which are hidden by default. One of the controls on the form is a listbox (lboRoles), where a user can add one or more roles to contacts. The listbox has a hidden column that...

Hi, I have a table (tblConversions) that I'm using as a base for replacing values in a different table. tblConversions is set up as such and is made up of nearly 100 records: ID LABEL CODE 1 Ashaway ASH 2 Barrington BAR 3 Bristol...

I am attempting to use 2 fields from a query to supply the Top and Left Properties of a Collection of Rectangle Controls on my form. The purpose of this is to display the locations on a map of "Spots" in a haunted house I help run. The query that I am using shows the spots that have been...

I am trying to copy a table (structure and data) from my application to another database using the DoCmd.CopyObject method, but it is not working... Here is my code: DoCmd.CopyObject "C:\iHaunt\Resources\Update.accdb", "tblParameters", acTable, "tblParameters" DoCmd.OpenForm...

This one is really bugging me and I can figure it out for the life of me. I have a form (frmSelect) that can be opened from different forms that acts as a code selection form. I have an unbound listbox and 2 textboxes that are hidden (txtForm and txtControl). On another form I have on the...

I have created a table by importing data from a .txt file. The text file is tab-delimited and exported from Google Spreadsheets. The fields are: Timestamp First Name Last Name Street Address City/Town State Zip Phone Birthdate Email When I first imported the data into the brand-new table, i...

I work at a library and I have an Access DB that I use as an active shelflist (all the items that are in our library). I have a query that breaks down the collection count, number of items in that collection currently checked out, and the number of items in that collection set to storage...

I found this code online from http://www.mvps.org/access/tables/tbl0009.htm. However, I'm not exactly sure how to implement it in my Front End. I copied the code into a new module, then put this in the OnLoad Event of my startup form: Call fRefreshLinks() But for some reason, the dialog box...

Hi there. I have a volunteer sign in form that has an unbound textbox (txtBarcode) and a Command Button (cmdSignIn). Our workers have ID badges with barcodes that are linked to their records. When a worker scans his/her barcode, the command button should do the following: Private Sub...

Is there a way to open a form, but have it hidden? I have a form that opens after a user logs in to the database that has certain permissions that I would be referring to when a user opens forms and such. I tried using the "Hidden Attribute" when I right-click on the object in the database...

I tried giving this a thorough search here, but I came up blank. I have a combobox on my Worker's form that displays a worker's Parish (church) that he/she belongs to. On the Double-Click event of the combobox, I have a Parish form that pops up. On this form, there is a listbox that displays...

Hi there. Could someone please tell me what I'm doing wrong? I have the following code for a command button, which is supposed to delete the row in a table that matches the ID number selected in a listbox: Private Sub cmdRemoveQueue_Click() Dim SQL As String Dim bID As String...

For the library I work at, I designed a Shelflist Database. This keeps all of our items records that I export from our ILS (integrated library system). I have a form that I designed as a spine label generator. I have an unbound textbox where I scan a book barcode then an Append query takes that...

I have a form that my users can create lists of volunteers based on criteria from their worker record. The subform is based on one query that has for each searchable field, this criteria (as an example): [WorkerType1]=[Forms]![frmCreateLists]![WorkerType1] Or...

I have a continuous subform that lists all volunteers working on a given night for our haunted house, which also shows what Room, and Spot they are in. Right now it sorts by ID number, but I would like to be able to click on any of the headers to sort alphabetically by them. Ex, clicking the...

Hey there. I have a search form where users can search for workers. The results are displayed in a listbox. From there, the user can double click on a name to open that worker's record. What I would like to happen is if there is only 1 result (a perfect match) I would like the worker's record to...

I have a volunteer tracker DB, and on my Worker's form, there is a subform that shows each night a volunteer has worked. The subform's recordsource is tblTransactions, the fields which include tID, DateID, Worker, TimeIn, and TimeOut. I have a form that runs in the background that has a...

I am looking to come up with statistics for my volunteer tracker. I have a table of transactions that records who works each night we are building our haunted house. These transaction records record the Date, Worker and the Time In & Time Out. I would like (probably a cross tab query) that lists...