Recent content by tabitha

I also posted this question on the VBA board, and I've solved it. Here's the link to the post! http://www.access-programmers.co.uk/forums/showthread.php?t=287879

Okay, so contrary to what everything I was reading, it worked as soon as I set it to only run when I'm logged on, without highest privileges! Here's my steps: -I wanted to see if it would run at all. At this point, it was set to Run whether or not I'm logged in, with Highest Privileges. >It...

Locking produces the same result. The printer is actually directly connected, since it's the little one that has the manual feed for the envelopes. I can see in the Task Scheduler History that it completed, and I can see on my .log file exactly when it ended, since that's the last step of the...

A fire risk? I'm not OSHA, so I don't know what you mean haha We're a small office, and we're only open 8-4:30, so ideally I'd like to have it run at 7:30am so it's finished when we get here. I have only been testing it during the day, while I'm at work. I'm able to double click the batch...

I originally put this in General because it's actually a bit of everything, but if there's something I can put in my code, that's great with me. So my goal is to print a report with a list of names, a stack of letters to each person, and an envelope with each persons name on it WHILE no one is...

I put this in General because it's actually a bit of everything.. So my goal is to print a report with a list of names, a stack of letters to each person, and an envelope with each persons name on it WHILE no one is logged onto the computer. I want this to run early in the morning on the first...

Okay, I just realized the same thing is happening for the Beneficiaries. I go to type a first name, it does, and it fills in the InsID with the correct ID. However, as soon as I click to the next record, it pulls an already existing Beneficiary record. And this form is a Continuous Form, not a...

I know that this is a server side issue, so here is the link to the same issue, in the SQL section of the forum, so unless someone reads this and knows exactly what to do, this thread can die. http://www.access-programmers.co.uk/forums/showthread.php?t=286392

I've attached a few screenshots showing the symptom on Access. I know it's a server side issue because I opened an old copy of the Access front end and the same thing happened. So what I did was I had the main Insured table, and an InsuredDates table, that, using a trigger, would create a...

I've attached a few screenshots that show the issue. I know it's an issue from the server because I opened an old copy that's linked to the same server, and it did it too.

So [CarsRented].[ID] = [ColorTable].[ColorTableID] and [CarsRented].[ID] = [Model].[ModelTableID]? And there's a Notes field in both the ColorTable and the Model table. So I would say in the After Update event for the Color toggle write : Dim GetID as string GetID =...

Can you tell me a little more about how the tables are set up? You said you have a different one for each thing, can you tell me the parent table's pk and how it gets the notes for each category?

I have a SQLExpress 2014 back end and an Access 2013 front end, and up until today, I have been able to have one form that is set to data entry, with two subforms that are not set to data entry, then a duplicate main form that's not set to data entry that uses the same two subforms to view...

I think you could leave the Notes textbox as unbound, then in the AfterUpdate event of the radio button, do a dlookup to find the Notes that are associated with that record.

This is the issue I'm having. I have a "Add New Insured" form, and after entering a FirstName, it refreshes, so the two subforms below will appear and show blank fields for population. However, starting today, once a name is entered, the form is filled with an already exiting record. (I checked...