Search results

That was one of the ways I thought of and mentioned. The problem is then I end up with a table, let's say BudgetedHours, and in that table I have the fields: Employee WeekEndingDate Hours Then all 2000 employees have to be listed 52 times. That would create so many records that I'm...

I have a Db that keeps track of each Departments budgeted hours and relative cost, as well as the actual hours and cost. To calculate variance. I have my tables set up for the actual, this comes in the form of a report through Excel so it's easily imported to a table. It contains Name, week...

That's exactly why I don't want to write it into a table, that seems unnecessary. But I need the dates to display on the header of the form then underneath that the managers need to put in the number of hours they want to budget for that person to work for each week. I need them to fill it out...

I have a datasheet form I'm trying to create, the columns are things like Department, Division, PayRate, CName, etc. That information is all based off of a table. Now what I need are columns off to the right representing the weeks in the fiscal year. So the header would be, for example, Week...

Thank you! Got everything to work and even figured out how to do unnamed ranges for the few that have cells grouped together, such as: Sheets("Sheet2").Range("BR16:BS33").Value = Sheets("Sheet2").Range("C9:D26").Value Thank you so much for getting me started!

This should be simple but I'm not seeing it for some reason. All I need to do is copy the value of Sheet1.cell and paste it to Sheet2.cell, in some cases I will need to paste the same value into multiple cells on Sheet2 though they are spread throughout. Any examples of how to do this would be...

In order to hard code the saving of a file, or use a template I would have to have a path and file name that each user would be able to access. That doesn't exist so I have to create a new file with no set name each time and let the user save it as they wish. Even though all the users have...

This should be simple but it's making me crazy. I just want to run a series of DoCmd.TransferSpreadsheet commands to export several queries to one Excel Workbook with seperate sheet names for each query. However my problem is I want this to be a new instance of Excel that the user will then...

The spreadsheet I've attached contains a ton of calculated cells and linked data. The people who created and utilize it aren't necessarily interested in changing the way they use it or populate it each quarter. That being said, my task is to somehow create a way that it can be sent to/seen...

Oh if I only I could name the fields. Lol. Would save me a lot of headaches. I was afraid that was going to be the answer, was really hoping I was wrong. Oh well, worth a shot. Thank you!

I have a crosstab query, among other things, it counts the field Policy Number to tell me how many policies were sold. Those are a unique value anyway so that count is accurate. I'm also trying to get it to tell me the number of agents that sold those policies. I need it to count the Agent #...

Duh. I'm not sure why I have 2 queries either. Well I don't now, and everything works fine. So thank you. It is still really slow for some reason. Compact and Repair, analyzed everything. Indexing seems fine. And I'm still developing so it's not split and is actually stored on my desktop right...

Okay, it did work so I just have the 2 queries, that one and the first one to copy AgentNumber into PrimaryAgentNumber. Which isn't bad, but the table has about 400,000 records so they do take a minute to run. It's not terrible but would definitely be better in VBA. But as long as it works...

Okay, I created an update query to update the AgentNumber to strReverse([AgentNumber]) so now that I have the numbers reversed all I need to do is update characters 6 & 7 to 0's. Not quite sure what the code would be to just replace those to characters no matter what they currently are...

It seems like strReverse would be the simpler way to go about it. Am I correct in thinking that I can't do this with an update query? If so, then in VBA I would basically do something like Update EA_ActiveLife_East.AgentNumber = strReverse(left(strReverse(AgentNumber),5) & "00" &...

I'm familiar with writing a replace query to replace characters or strings but what I'm trying to do this time is a bit unique to me. I have a string of numbers that will either be 8 or 9 digits in length. The first 1 or 2 digits will be the State code (1-50 hence the discrepancy in number...

I got it to loop through the sheets and create a TempTable. However there is a type conversion error on one of the fields, which I think is odd since it's creating the table. It happens to be a field that I don't need anyway so I'm not really worried about that part, and I can write the VBA to...

I have an Excel workbook with multiple sheets, all the sheets have the same headers and are formatted the same. Problem 1 is I need some sort of loop so that all sheets will be imported, the names will vary so I can't use specific names to import. Problem 2 is that I need to create a new...

Yes, you can see them all. They really aren't that large. I USED to have no code, now I have a Me.requery in the OnLoad of the main form. That's how I fixed it. Still don't really know what caused it, but it's fixed anyway. And just out of curiosity, if it were the case that the form was too...

I took out all the requeries of the subforms and just used a Me.Requery in the OnLoad of the main form and that seems to have fixed it. Weird.