Search results

Ok that makes sense. I don't need to store it in the table but I have to then tally up all the sub totals. So the continuous form has 5 records in it for 5 different employees. I set the total field to: =[Week1]+[Week2]+[week3]+[week4] This gives me the total for each record. I then need a...

Ok I got it by changing it a little to this. =[Week1]+[Week2]+[week3]+[week4] But I still need it to be stored in the total field. If I put [total]=[Week1]+[Week2]+[week3]+[week4] I get an error Also me!total=[Week1]+[Week2]+[week3]+[week4] gets an error Gotta be something simple I am missing

I tried what you said but I am getting an error. I am using Access 2007 btw. I changed the Control Source of the field "Total" and it shows "#Name?" when I switch to form view. Also if I have a formula in the control source, how will it be stored in the table?

Hi all, I have a project with a parent form called Projects. Inside projects there are multiple tabs with continuous subforms. On subform has a field in place to total the other fields. So I have some code that totals all these fields on a button click. Sub Admintotal_Click() Me.Total =...

I am getting a "compile error: expected end of statement" around the SourthPath Line. I have modified the code to be relevant to my C drive for now. Function FolderBuilder() Dim SourcePath As String Dim DestPath As String SourcePath = "C:\Power & Industrial\Projects\Ztemplate" DestPath =...

I have created a database that my company uses for project proposals. Of course associated with any project is multiple documents that get stored in numerous locations. I have created a blank directory structure that I copy/paste for each no project to the shared server drive. Would it be...

Plog, The table that the form is based on is completely separate. I know the names are the same, I just haven't changed it to what a previous user had there. I am going back and updating the fields to make them more specific to avoid any problems. Thank you for your input on it though, it will...

Ah of course...Completely missed that. It's always the little things. Thank you for you help Cheers

I do this quite a bit. In office 2007, I use the macro command, transfer spreadsheet under macro's. I also set the upload to a temp table. So the Macro is something like: SetWarnings: No OpenQuery: CleanTemp (which runs a delete query to wipe the temp table) TransferSpreadsheet: (Enter...

I have used the DLookup function many times in VBA, but I am trying to use it in a slightly different manner this time and I can't figure out wheat I am missing. I have a table called MarketRates, it has 2 fields; CCode and Rates I have a form that I want to look up the rate based on the code...

Excellent thank you very much that works perfectly.

Hmmm lol ok that was easy. Can't believe I didn't see that. Thank you for your help. It ran just as expected, but proposes another problem. It didn't create any records. Currently there is 1 record in the zEMPMain table and 0 records in the CICMH table. They both have their primary key...

I am trying without any success writing an append query in my database. I have done it many times before but not with such a limited scope. I have a main table called zEMPMain. This is the main data storage. I have another table called CICMH. This is the table that I want to append new...

What you are explaining to me now makes a lot more sense. I will work on rolling up all the tables into a few simplified ones using the method you described. I also think I will leave out the long vertical columns in the form and just stick with discipline totals then use a query later on to...

Ok here goes... The model that I am making is for the scheduling of manhours over a project. It starts in the project table where basic information is filled out such as project name date of start, project type, client, total hours, and projected hours. The user will then go to a set of...

Well its a little complicated, and I am about to get sucked into a meeting. I will respond later this evening or in the morning and try to state what I am trying to accomplish a little more clearly. I certainly want to follow the most proper route to prevent myself from building some...

Thank you for the reply, I greatly appreciate it. The reason for so many 1 to 1 relationships, and I could be wrong in my way of thinking is because of the amount of fields in each table. For Example, my main form is Project, this contains the main record number ID (auto-generated). It also...

Greetings all, first time on these boards. I have been desperately trying to figure out a way to create relationships using VBA as I have a load of them to do. I have a base code built that I need to replicate, but I am getting hung up on a small error that is occurring. I have a main table...