Search results

I've got a form that has three separate dates in it (for this they are Date1, Date2, and Date3). These dates are tied to an individual record, so what I want to be able to do in that record is find the earliest date between the three, but all three might not always have a value in them. I've...

I've got a listbox that I'm trying to run a command that will set a checkbox value in the associated table to yes. The listbox (lstPersonnel) has two columns (Name and Member Number). What I want to happen after I select the records I want, is to update the value in those records...

I'm trying to create a crosstab query that relies on dynamic column headings (user can change which columns are visible). How I want it to look: Present Admin 1 Operations 2 How it's showing up: Leave Present 0 Admin 1 Operations 2 While I do want all of...

I'm trying to create a query that compiles a running total of different criteria, but I'm hitting a roadblock by not adding an AND to my DCount function. What I want the query to do is count every selection of either Present or Leave for each Department without it displaying a total of 2 for...

I currently have a fairly good sized (9 mb) database that I have shared with people. Upon initial installation, they are prompted to enter their local network data (basically where their copy of the database will be residing on their network). As I make updates to the FE file, I make it...

I have a continuous form that will display records if they are selected [UseForTracking] in a separate form. These records already have a number value [Order] assigned in the source table, but these values can be changed by the user to adjust the order they are displayed in. What I want to...

I'm trying to insert a set of values into a table using SQL. Here's my code: DoCmd.RunSQL "INSERT INTO tblAuditTrail([DateTime], [UserName], [RecordID], [Action], [FieldName], [OldValue], [NewValue])VALUES (" & Now() & ", " & User & ", & Me.CSM & ", " & 'EDIT' & ", " & 'Location' & ", " &...

Instead of using an update query, so my Audit Trail will continue to update correctly, I'd like to use an input box and run a function that performs much like an update query. My problem is, only one out of 4 records updates correctly. Me.txtTranTo = InputBox("Enter Location Transferring...

I am using an audit trail on my database that works perfectly. My question is, can I run an update query and still log any updates through the audit process? I suppose the update query is not a necessity, but it would be nice to retain it if possible.

I have a few update queries that will check X number of items, based on what the user inputs. What I want to do (if possible), is return the number of items selected based on what they type in a message box. I have set all warnings to false for update queries. Example: User runs the...

I've searched, and searched, and searched, but no dice. I've got a continuous form that displays my massive 3,000+ inventory, with the option to filter down to specific categories. Some categories have 5 items, others have hundreds. The design I have used makes it look really tacky once I...

I have a log of items I currently inventory. When you click on an item, it opens another form with a sub-form that lists the history of changes for said item in a continuous form display. What I want to be able to do is when that form is opened, the sub-form will highlight the last entry...

I'm trying to breakdown a date into years, months, and days. Simple right? The code I've been using for months returns a negative month if it happens to be the next month. Instead of returning 1 Year, 1 Month, 23 Days, it will instead return 1 Year, -1 Month, 23 Days. Code is: Months...

I'm in the process of creating a database in Access 2010 that has two front ends, basically. What I want to be able to do is lock out one of those front ends for a specific period of time every day. Does anyone have an example they can share?

I have a query which works perfectly fine, it's the report that I'm having issues with displaying correctly. My report is a daily personnel accountability report that shows where everyone is for the day. Instead of having a cumbersome query like I did before, I have opted to just use the...

[SOLVED] Referencing text from drop-down vice ID number I know this is simple, but I feel like Simple Jack this morning. I'm trying to take the text from a drop-down menu and use that as part of the form caption. However, the text is not what is bound, the ID number is. I know I'm going to...

I know it's possible, and I don't even have this thing built yet, but I want to create a database that utilizes the user's ID card to authenticate them and tie any changes to their name. If not that way, using their stored information (SSN, or other ID) as a means of creating a...

I have two tables one with all the personnel (tblPersonnel) I'm tracking, another with different report names (tblReports). For each report, there are different years that it's valid for. On the reports table, I have three columns, ReportID, Report_Title, and Years_Valid I'm using a...

Is there a way to remove data from one or multiple fields if the value of a separate field IsNotNull?

I've got a main form (frmPersonnel) with the the record ID as a clickable action. When a user clicks on the ID, another form opens where they can add specific information for that record alone. I have two tables (tblPersonnel and tblLocalInfo) that are linked via relationships. Everything...