Search results

no not at all, its my own bad habit :) this is why i doodle on screen shots of my forms and the like whilst working on them :) i like to be awkward and not have people fiddle, and there are quite a few fiddlers in my office i can tell you ! thanks for your help :) Christophe

ahhh however if i set the default values to "" then it works :) and my user is suitably abused :) thank you yarp :) adds kudos.

thanks Yarp, when i try that it still loads the report if the combos have any value or not. Private Sub reportpreview_Click() On Error GoTo Err_reportpreview_Click If Me.Combo86.Value = " " Or Me.Combo88.Value = " " Then MsgBox "You are a stupid user" Else Dim stDocName As String...

Private Sub reportpreview_Click() On Error GoTo Err_reportpreview_Click Dim stDocName As String stDocName = "qry_costs" DoCmd.OpenReport stDocName, acPreview Exit_reportpreview_Click: Exit Sub Err_reportpreview_Click: MsgBox Err.Description Resume...

I have two drop down menus on a form which are used to select a special date range (using sap week numbering) they are called: Combo86 Combo88 these values are used in a query which is run when a user selects a report. The question is, how do i alert the stupid user who is trying to run a...

By my reckoning, this should also work, if put on a button ... Set db = CurrentDb Set rs = db.OpenRecordset("tbl_esttime") rs.AddNew rs("Job No") = =[Forms]![frm_jobsetup1]![Project Code] rs("Staff Member") = "Project Manager" rs("Hours") = 0 rs.Update rs.Close also, why a bad idea to have on...

My reason for asking vbaInet is that the job no will vary depending upon the project that i am working on at the time ... so this will not be a fixed code.

so if i use the SQL Insert which would give me something like: INSERT INTO tbl_esttime (Staff staffmember, Hours) VALUES (Technician, 0); How would i be able to reference the job number ? my plan was to have a button on a form which say ... on load write values to table esttime, from what i...

seems to do the trick, using an inner join, i have not used an outer join before, i do not think anyway.... any pointers ?

I have a table called tbl_esttime, what i want to be able to do is that on the click event of a button - write values to the table, so my table structure is: tbl_esttime ID Job NO Staff Member Hours What i need to do is write 5 new records in the table, as such: Job NO Staff...

Okay so i have changed the relationship from JobNO - Job NO to Grade - Grade, and as long as both tables contain the list of grades, it seems to work ... is there anyway of doing this so that i do not need to have a list of all the grades that *might* appear in tbl_finance in tbl_estime with 0...

I have two tables: tbl_finance actually records the hours worked on a job, whereas tbl_esttime records the hours that I think are going to be worked on a project (for estimating budget purposes) When i run qry_estimatedhours - i get a nice total of the number of hours by grade that are...

I have a lookup query which references tbl_projectdetails: SELECT tbl_projectdetails.[Project Code], tbl_projectdetails.[Service Area], tbl_projectdetails.[Project Title], tbl_projectdetails.[Work Stage], tbl_projectdetails.[Project Director], tbl_projectdetails.[Project Manager]...

Works a treat :) thank you very much vbaInet :) you are a star.

I have a short piece of code behind a button: Private Sub miniwip_Click() On Error GoTo Err_miniwip_Click Dim stDocName As String stDocName = "qry_to calcuate costs for est time hours" DoCmd.OpenQuery stDocName, acNormal, acEdit 'run first make table query for finance...

Short read of the Acces 2003 bible later and we have the following expression incorporating NULL ahhhh you have shown me the way :) thanks guys :) adds kudos

Okay, the concept of NULL is new to me, would you mind elaborating further PNGBill, many thanks. I attached examples of the query showing when there is a [FD3.6 Fee] value and [Estimated Fee] i guess part of the problem is the relationship between the tables where on the relationship is set to...

There will always be a value for [estimated fee] this can vary from £30 to a couple of grand, but it is not always the case that there is an FD3.6 fee to go with [estimated fee] The way round this is to assign a zero value to every live project in the FD3.6tbl, but this is not an idea way of...

I have a report which pulls in data from three related tables, the fields are: Job NO Job Title Spend Estimated Fee FD3.6 Fees Fee Remaining % Spend of these fields, the last three are caculated on the report. Now the problem i am having which occurs at both query and report level is that when...

Solved, the problem was the " " i had in [ form] thanks anyway