Search results

This is my code: Function CheckZipMain() As Byte Dim dbs As DAO.Database Dim rstZip As DAO.Recordset Dim stCurrent As String Dim stCorrect As String Dim stCurrentZip As String Dim stCurrentState As String Dim stCurrentCity As String Dim stMsg As String Dim stCorrectCity As String Dim...

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 just created another query that filtered on employee, then two separate reports linked to each query, then did a DoCmd.RunSavedImportExport and named them each "UPMC With Deps" and "UPMC Without Deps". It doesn't have the date, but such is life.

To give some more info.. Here is what I had, and for the most part it worked: Dim stDocName As String 'I have a check box as to whether we want the employee's dependents to be included, so if 'the box is checked, it set the [Relationship] to "Sub" which means an employee. If...

More like the ONE company that we use (among 20) is demanding it. Since they have nothing to do with our database, and our database was created some 15 years ago, there was no way to prevent this. One of the other companies conveniently just asked for their already existing Employee_ID which I...

I need this because I'm uploading a template of a census to a website, and the first column is Row_ID and it wants them numbered. I don't care if John Doe is Row_ID 1 every time, because I'm running the query on many different companies (whatever the user chooses) but I want it to be Row_ID 1 2...

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?

Nevermind, I realized that it wasn't the parentheses that was the problem, it was the character length. I trimmed it to exactly 64 characters and it was successful.

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

Genius!! I never thought to add an entirely new field to just make what I wanted, and it worked just like I need it to. Live and learn! Thanks a bunch!

So how do I override that? Can I change the primary sort?

They aren't alphabetical for me? I'm not sure what you're seeing, but when I look at this picture, they aren't in order. It should go Adams, Smith, Wilson.

I've made a copy of the database and deleted all the personal information with just one test company and three employees with their dependents. If you double click on the Census Union form, then type "ABC" and click the button, it will run the report. You'll see if you go into Design View, that...

How would I post a sample?

Man I'm still stumped by this. Everything I'm reading online just says "Use Group, Sort, and Total ribbon at the bottom" and while this works for one level, it just fails beyond that. I can group by [Employee ID] and do no other grouping or sorting; I can group by [Last] and do nothing else; I...

Both union tables have and [Employee ID] field, it's what links them together. I have the grouping first because sometimes a dependent will have a different last name, and if I sort by name first, they won't be together. I want the Relationship desc so the Subscriber would be first, then Spouse...

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

Oh my goodness, you're absolutely right, it was considering the checkbox as Null because I hadn't clicked and unclicked it before running the report! This is great, thanks! Now I just need it to sort properly lol

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