Search results

Can someone look through this code and give a hand? I'm running into an issue where if the user clicks No on the msgbox at the end of the code, nothing is updated in the record. If they click yes, then it will update the record. The message box's purpose is to allow the user to rerun the form or...

I have a bound combo box that the dropdown portion displays 2 columns. The bound column is 1, and the columns of the query I am displaying are 3 and 4. Is there a way to make it so that when a line is selected, only the value from column 4 shows up in the combo box? I have a dependent...

I'm new to Access/VBA and I want to get opinions from y'all who have more experience on whether or not this is a bad practice while I'm early on in my database design/skill development. My database has a bunch of forms which allow FE users to enter and selectively edit information. I am...

Okay, I'm not even sure if this is possible, but I'll ask anyway. Purely an aesthetic thing, but I'd like to make my form stop highlighting a field when it loads. This form loads after a user double clicks on a particular record in a continuous form so they can edit the QC Disposition block...

I currently have a form which is populated by data pulled from a single parameter query [Enter Batch Number to be modified]. When I open the form an the popup appears, if I enter a batch number that exists in the table, it returns the appropriate record to the form. If I enter an incorrect...

Okay, so I've dug around here and found several ways to do this, but none that meet my specific need, or the solution isn't clear enough for me as a new Access/VB user to understand where to implement it. My dbase has a table to track samples that come into our chemical lab for QC approval...

Option Compare Database Option Explicit Private Sub btnClosefrmRPRLLogin_Click() DoCmd.Close 'Closes Form on Click End Sub Private Sub btnLoginPaperwork_Click() DateTimeIn 'Timestamps DateTimeIn Field MsgBox "Repack/Relabel Paperwork Sucessfully Logged In", vbOKOnly, "Thank...

I created a split form (see attached image) to allow people to logout paperwork that has been entered into the database I'm building. The idea is to allow the people completing the paperwork (or sample testing once I get around to those forms) to select which paperwork they have finished and...

In order to make a timestamp in several of my tables, I have built a macro based on a post on the Microsoft office support page "Store the Date and time when a record is modified" My Macro is: SetValue Item = [DateTimeIn] Expression = Now() CloseWindow Object Type...

The database I am designing needs to be able to calculate the turn around time (T.A.T.) on samples being processed. Each record in the main table will have a lot of data for each sample, but the times that are being recorded are in three fields: DateIn (Will autopopulate when the record is...

Hello from South Carolina, USA! I am a chemist at a manufacturing facility who is new to using Access. I am developing a database for us to track our samples as they are brought into the lab for testing. When I'm not on the clock I am spending time with family (wife and two dogs), or...