Search results

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

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 have a procedure I want to run each time a control box is updated, but the code I have is a For Each because it was made to run only once at the Form's After Update event. But when I do that, it doesn't pick up the change. Anyone know how to properly remove a For Each - while still capturing...

Hi, I'm trying to create a connection to my SQL back end from my Access front end using ADODB, and I've been unsuccessful so far. I'm running SQL Express 2014 on Windows Server 2012, to Access 2013 on Windows 7, Here is my code: Private Function TestADODB() Dim rs As ADODB.Recordset Dim...

I need to be able to assign a title to a set of dependents that is not what they are normally called. As in, every dependent is either called "Dependent" or "Step Child", but I need to call them "Child1" "Child2" "Child3" etc, for however many children an employee has. I have a function that...

It's really weird and I don't know what to do. I work in three different databases, but for one of them (the main company db), if I right clicked the pinned Access program on the taskbar and click the pinned database, it does nothing if someone else has the file open already. If the file isn't...

Does anyone know if it's possible to use a union query as a mail merge? I haven't found anything that says I can't do it, but I'm not getting my merge to complete, and when I switch to a plain query (and not changing anything else) my merge is successful, so I'm thinking there might be a...

So I have a form for addresses that checks against a table of US zip codes, and throws up a warning if the City/State/Zip entered isn't found on the table. This works great. But I was wondering if there was a way to list the available combinations based on the zip code entered. I want the...

I have a form where you can select four different options: Health, Dental, Vision, and COBRA, with a button to run a census. Right now, the button runs a DoCMD.OpenReport to open a report named "Census" where there are four text boxes, "Health Coverage Type" "Dental Coverage Type" "Vision...

I know there's no rownumber function native to Access, but does anyone have a good alternative? I have two tables in a union query, and I need to add a sequential Row_ID to the end result. I was hoping to avoid using a report, and just stick to a query that I can quickly export. Any ideas?

I'm trying to export either a report or a query to excel with a field name that has special characters "()". I wouldn't normally ever do this (everyone knows not to use special characters) but we're using this to import the excel document to a website, and the field name MUST be what they...

I have a union query of the Employees table and Dependents table on [Employee ID] which I build for a census report, and when I run the query, it sorts correctly, but it's not sorted at all on the report. I tried to add a sort on the group, but it just ignores it. I need it grouped by...

I need to create a census report from the employees we serve and their dependents, by company. I have a union query of the Employees table and Dependents table to put them all on one list, then a form where you can type the name of the company you need, with a button that opens the report. This...

Just a stop to say hi. I'm the Database Administrator for a small insurance company, and I've only been here for three months and have been tasked with normalizing their ancient Access database into something actually useful. I've been doing alright so far, but now I'm trying to create...