Search results

This is a discussion in theory / best practice only. How do you decide when to create a second, or third etc. database instead of just adding more tables to your existing database? What so called "tips the scales" one way or the other? I am still very new to this so kind of looking for a...

I had a form with a Sub Form. When I entered a product Serial number on the main form, the Subform would update to show any prior entries for that serial number. No programing was needed. It worked great. Then I added a second Subform for Windows License information. I added a routine to the...

I have a continuous Form for logging paperwork received. Very Basic. Just the reference number of the paperwork and how many items were received, along with date etc. Would it be possible to invert the Continuous Form? Currently it lists the first item entered at the top with the second item on...

Just want to pass along this incase any other newbie is reading this. I started out making my database and I really did not pay enough attention to my Table and Field names. (Or queries or reports either.) I read things that said do this or do that. And at one point I started doing things the...

Just a few things I want to be sure I am understanding properly: 1. In my DB I use a PartNum field set as text. The part numbers consist of a series of numbers (usually 6 numbers but not always.) On occasion the numbers will have a letter suffix (123456-A) or a letter prefix (S123456) or...

(Running Access365) As I am trying to learn VBA I am experimenting with the On Event feature of some of my forms. Just something simple so I can understand what is happening and when. Just a simple place to start. I tried to set it up so that when the cursor left one field the program would...

I am designing a form to enter date and employee information to use to run some reports. The basic form functions as expected but does not look like I expect. I have attached 2 screen snips showing the Design View and the Form view. Why does the form fill the page when I give it a width? I...

i am looking for resources on how to learn to write code for Access. While looking on the web it appears that I can either get books on Access or on SQL. Should I be learning VBA or SQL? I do not anticipate using it much beyond this current project. I already have a functioning database but...

NOOB question here. I have an equipment testing log database that uses a Short Text field for Serial Number (Some serial numbers have characters in them). I have a query that uses the Criteria of [Enter Serial Number] for the Serial Number field. If the Serial number exists it display a form...

I have a simple form I created using the form wizard that I use to enter part numbers. I added come control buttons to the form to close the form, see last record etc. I also added a Enter new part number button. When I click the button, the form clears and goes into entry mode as expected...

I am looking for where to learn how to do this, not have some one do it for me. Note: Everything I have done so far has been through the built in Access wizards etc. I have written no code. I have a number of reports that use dates that are put in to the query by Message Box. I have attached a...

(Rookie Access user) When I try to create a ACCDE from my database, I get an error that says Microsoft Access cannot create the file. Reading through the forums, it appears that the most common problem is with bad VBA code. I have no self written VBA code. Everything I have is done by the built...

I have extremely limited experience so please be gentle. I have a maintenance database with over 6k records. I have a form for entering the individual tests. I have made this form a split form. When I enter the Serial Number in the Main Form (left side) I want the Split Form(Right side) to...

I have a macro to check for a password before opening a form. (I know not the most secure but secure enough for my need) I have it working with a number password, but I would like to use a text password. Right now it is "5234" and i want it to be, for example "Go Knights Go!" What do I need to...

I have a QA test results Database where the employee enters their name from a dropdown list every time the make an entry. I have a table that has their name and number. In the database I am only storing their number. I have a query to show how many entries an employee made during an entered date...

I found a PDF of the book "Access VBA Programing for Dummies" by Alan Simpson, on line. I was wondering if that is a good place to start to learn VBA in general and VBA for Access in particular. Thoughts?

Where can I find help that does not give answers in programing languages? I posted about a problem with a search returning no records and no way to get back to my switchboard. I got a quick response (Thanks) but it was a page full of VBA code. I asked for clarification on what to change to fit...

I have a database that contains equipment serial numbers. I have a switchboard set up to run the database. One option is to search by serial number. When I enter an existing number, everything works fine. I have a button on the form to return to the switchboard. The problem is if I enter a...

Trying to take advantage of the COVID-19 shutdown and convert a 5,000+ line Excel test result log to a database. Been a challenge to say the least. I have a few points I am stuck on and look forward to the groups help.