Search results

Hi Bob - Thanks for the help last night. I did try to run the code again and got the same error (attached). Since the query runs from the DoCmd, I can run it from there. It would just mean the EU will have to input the Quarter. Any suggestions on exporting the make table to a Text file...

This line - as a text string - gets batched to Medicare and the Medicare system expects those carrots. So we wrote them into the Line.

Hey Bob - this is a different subject - but I have a feeling if anyone knows, it's you.... I have made my array, populated a table, built my three queries with the last one being called from the end of my code and it's all beautiful. I used a docmd.openquery to run the final query. It asks...

Thanks for the help.

BTW - I did try to compress and zip - that was 4.4mb. Original size is 17.1mb for the structure and 65mb for the dataset. I dumped all the dataset except for mine. I have 300+ employees using this database every day for one month per qtr per year.

Hi Bob - Thanks - that helped and I forgot to flush the array all the way. I grabbed 1-end instead of 0-end. The 0 hit 32700 real fast and got too full.

OK - so I had my boss - who I call Database Yoda - take a look and we decided that building a function that passes the info into an array and making a temptable would best pull what we need to build the crossover table. I have an issue though - I am getting an OverFlow error on run. I...

I don't see where the file went - I checked - it is 4MB zipped. It is a huge DB.

Hi Bob - I have stripped it down to where only my info shows. But it gives you structural relativity. One thing I have noticed that I am working on is the Activities Report Data (which I was using as a bridge for Record_No and Task Code) on my query DTSbyWeek repopulates by the week the...

I will in a bit - I need to strip it out (confidentials)

Hey Bob - That didn't change the results. Thanks for trying.

Thanks Bob - still innaccurate data... I attached my (personal) data - because I know it's wrong. But I think if I write an 5 Expressions based on week where [Week]=1 (etc) into the count it will fix my problem. It is adding the entire first month of the both Qtrs even though there is a choice...

Thanks Big John Booty - I wish it were that easy. I have attached the results - it would mean that the employee had the same exact codes each day of that week. It doesn't tell me how many of each code they had. Oh well - looking for a short cut but it looks like I will be writing all day!

I have a query which contains the following: Input criteria for Year and Qtr Staff ID Week Code There are 96 code entries per day so staff ID "2818" for week "1" has 672 listings for that week. I need a query that will add how many of a certain code they had in that week without writing...

Thank you so much.

Currently, we run several DBs in Access that generate emails to our users in Outlook. Last year we tried to upgrade our Outlook Libraries from v9 to v11 but the email commands would fail, looking at Access as a third party generated email and wanted human confirmation. Many of our automated DB...

The vbCRLF or CHR$(13) & CHR$(10) do not work in a Tab Caption. So even though my problem didn't get fixed, it did help me discern that it cannot be. It will work in a Label and on a Button... just not in a Tab Caption in Access.

Thank you so much. This really helped. Even though it was cosmetic, I wanted it to look a certain way. :)

I have a form with 7 tabs. Each Tab is for a day of the week. I have them where they are fixed height of .375, fixed width of .75. I had the Date sitting over the Day of the week in this code: Me.Tab1.Caption = CStr(Date1) + Chr$(13) + WeekdayName(1, False, vbSaturday) It worked on my...

Well - atleast now I know that I need to really pay attention to naming. It is way different than what you can get away with in other code. Thank you so much again!!!