Search results

For a patient couldn't you just reschedule them by putting them down for another day? Thanks very much for all your help, if this practice expands to more than one doctor, I think it would be a job for someone other than a first year student in civil engineering ;). Attached is (what i THINK)...

Just so we're on the same page healthcare_province is the province that pays for the public health care province is the province where the patient lives. healthcare_province is required for out of province patients, for example patients who come from BC to Alberta for surgery. so there is no...

I'm not sure how to store the path to the file, what type of field would this be? Originally I thought attachments were really handy, and I would scan files and attach them to the database until I realized that even if I deleted the files I could still access them from the database, so the...

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

Worked great with the first one, thanks!

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

I was going for a thermal label printer, not with the avery sheets because there only needs to be only 1 label each time, and it's a bit of a pain to feed the sheet back into the printer everytime. I have the label recordsource restricting which patient label I want to print, but the problem is...

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.

It works just fine on Lost Focus, but my client has asked me to try and get it to requery each letter to narrow down the patients in the search form.

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

I've found a totally alternate solution that you can whip up in less than ten minutes, using queries rather than filters (which seem to be much better!). What I've done is gone to the form's recordsource and used a query with different criteria. My View Schedule button now has the event Requery...

Do I add the code to the top or bottom of my segments? I've tried both and neither have seemed to have worked. I've come up with a temporary solution where at the end of my View All code, I have... Me.FilterOn = False Me.Filter = "" DoCmd.Close DoCmd.OpenForm "Day Schedule"...

Hi David, Thanks for your response. Your solution successfully resets all my control values, but unfortunately, it wasn't able to clear the filter. I'm still trying to apply multiple filters (NOT at the same time), but without going through the hassle of closing and opening the form.

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