Search results

OK, Now I feel stupid. I tried that before and It would not work. Now it does. It kept saying it could not find the name "Go Knights Go!" Now it works fine. Thanks for helping

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...

Although a valid point, I highly doubt we will ever have 99 employees doing this job at this location. in 10 years the most we ever had was 7 in the section and only 3 actually did work that the would have used the database had it existed then. I thought I was using just 9 or just 99 instead...

Why when setting the volume on your TV, it must be an even number or a number divisible by 5 (10, 15, 20) ?

Thank you. That worked. I did find an additional problem however. I have an employee using number 9 and I had 99 for tests by those without their own number. My query was lumping test by 9 and 99 together. I solved it by changing my not assigned number from 99 to 0. Might ot be hte best way but...

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...

OK, As I learn more about VBA I think I understand what you saying. Let me see if I have this "flow" correct: Switchboard selection opens my form; I have a OnOpen event set to run my VBA code My Code opens a message box asking what I am searching for; Then I transfer the message box...

Thanks. I do have a database that I am working on. It is doing a few things I want to change and don't know how. When I asked here, the answers were in VBA. I found a workaround for now but I need to understand VBA to figure out the "right" way to do things.

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?

One additional question: While looking online for VBA courses, most (all?) refer to Excel VBA. Does that matter? or is Excel VBA applicable only to Excel and the information will not translate to Access?

To all, I found a workaround. If I allow editing of the form (in form properties) it will show a blank form including the command button to return to the menu. For now, this will allow me to have a usable set up. As I gain experience and understanding of VBA and Access, I will implement the...

OK progress is being made. Using the code builder for the event "OpenForm" I have ended up with this: NumRec = DCount("*", "LocationSearchResults", "Source") If NumRec > 0 Then DoCmd.OpenForm "LocationSearchResults" Else MsgBox "There are no records to view."...

Thank you for your help. However I am using a form not a report. I do not see a "No Data" event for a form.

I have a database that is a record of equipment and software tested in my section. I have a switchboard that opens a Split Form that has fields from multiple tables that list things like Date Tested, Who tested it, What was the result etc. The lower half of the form is a Datasheet View showing...

YES!!!! I don't mind the code as long as I know what to change AND how (where) to plug it into Access.

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...

Thanks for responding. I am so knowledge challenged in VB, that I do not even know what to change in your code to match my form. Can you point out what I need to change? Also just to verify, I am using a form and this code will allow the form to work like it does now if the searched data...

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...

I will be sharing some of these. Thank you.

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.