Search results

Hi, so I've recently found out I should've normalized my tables before starting to enter data... but now I've got a big table but it doesn't make sense to me how to group things together. Attached is an image of what I have currently. What doesn't make sense to me is that each table needs some...

Hi, I found out today that Access has put a 2GB limit on the size of the database, which seems to be a problem for me. I have a large table, my patient list contains fields with healthcare number (primary key), Last name, first name, DOB, address, home/other phone, notes, referring MD, city...

I have a primary key, ULI, that has patient numbers in the format of #####-####, which are blacked out in the picture. The problem is the low number ULI's are substitutes for the real ones and I need a way to get the highest of these low numbers, but they are stored as text (because of the dash...

Does anyone know of a label printer with software that prints directly from Access? Right now I'm thinking of using the DYMO Label Writer 400 Turbo, Brother P-Touch QL-500 or Brother P-Touch QL-57. These only support word and excel though, so what I was thinking was to OutputTo a .rtf file...

Hi, I double click a listbox in my search form to get a string. I store the string under a TempVar called ULI, but when i go to the main form and apply FindRecord with [Tempvars]![ULI], it doesn't work. Find Record --> [TempVars]![ULI] Match: Whole Field Match Case: No Search: All Search as...

Hi, my database is in a trusted location, but I am unable to use macro actions such as SetValue, they just don't appear in the action list. I am using Vista and Access 2007.

Hi, I'm working on a tabbed search form that has text boxes to search a query. I have the textbox OnChange event to requery, but when it requeries its focus goes to the tab and I have to enter in 1 letter at time to continue searching. Is there some way I can prevent this, or at least redirect...

Hi, I'm making a search function for my form and I have it so that if I enter a doctor's number, his name will automatically be filled into the next space. Is it possible to be able to do the reverse (enter in the name and have the number come out). Currently on my form it says that the name is...

Hi, I've been having trouble with my filter not clearing properly. Essentially what I have is a split-form which displays all the appointments for a certain location when I click a "View Schedule" button. This works, but I also have a "View All" button to take me back to show all my records and...

Hi, I'm playing around with some macros on buttons and trying to turn the button invisible OnClick. btnSearch that has the macro SetProperty -> btnSearch -> Visible -> 0 I have all macros enabled but I still get the error 2950. The macro works if I choose any OTHER control to turn off...