Search results

I have found Allen Browne's article about misinterpreted calculated fields at http://allenbrowne.com/ser-45.html However, even when going into SQL and wrapping the calculation in CSng(), I'm still getting errors. Is there something else that I'm doing wrong? Sincerely, Bill

You're not supposed to press the button; you're supposed to click the combo box below that button and choose Station 1, 2, or 3. :D If you still have the energy to help me, and try looking again, I'd appreciate it. @wiklendt I agree with you and that is what I would like to do. In my...

I have 2 databases that have very similar queries yet 1 Sums up TextBox Values fine and the other Fails utterly. It would take me a lot longer to explain rather than me just showing you. To get to where I'm talking about: Go to Welcome Form, and under the Button which says "View LS and RS...

Bob, Yeah, it was referring to a combo box on the form for a criteria without quotes. Interesting, I've just found a limitation of Access :D! I've added the extra code to set warnings to true and the error handling stuff. Thanks a bunch. Sincerely, Bill

Thanks Bob. When I try the Delete then Append Method using this code: Dim qryName As String qryName = "qappStationOptions" CurrentDb.Execute "Delete * FROM tmpStationOptions", dbFailOnError CurrentDb.Execute qryName, dbOnError I get the following error message: "Too few parameters. Expected...

My current method for solving this problem is Dim qryName As String DoCmd.SetWarnings False qryName = "qmakStationOptions" DoCmd.OpenQuery qryName DoCmd.SetWarnings True pbaldy, thanks for the post. How would I empty the Table though? I assume Append could add records.

Thanks Bob; Guess that's what happens when I take too long to respond :rolleyes: I'm getting an Error though still. It says "Table 'tmpStationOptions' already exists." Basically I want it to overwrite the Current Table without trouble. :cool: Sincerely, Bill

Thanks pbaldy; exactly what I needed. Now I just need to figure out how to make Access just run the code without all the warning messages. :D Sincerely, Bill

Hi all, Basically I'd like to run my Make-Table Query as soon as a Form is Opened; however, I have only found the following. Dim SQL As String SQL = "UPDATE Employees " & _ "SET Employees.Title = 'Regional Sales Manager' " & _ "WHERE Employees.Title = 'Sales Manager'"...

Thanks for the reply WIS, All the Primary keys are set to Indexed, no duplicates allowed, and I have tried making another intermediary Table called StationOptions. I'm still running into the problem of my data repeating itself. For example in this picture: Station Name and Side are...

Thanks for the Reply Wazz. Here is what I'd get without any criteria and by displaying all 3 tables (for those who can't see images, it basically repeats BASE, SNRF, and 6CVT several times, then a # (BASE is always 1, SNRF always .474), and the Station). This in of itself is annoying but...

I have 3 tables, tblOptions, tblProcesses, and tblStations. Every Process has 1 Option while 1 Option can belong to many Processes. Each Process belongs to 1 Station while 1 Station can have many Processes. So essentially there is a many to many relationship between Options and Stations...

Well MSAccessRookie, That was a ton easier than I thought. Thanks a bunch :) Sincerely, Bill

Yes, I just want to Prepopulate this Field with these Values. If the user wants to change these Values later, I want to let him/her. (there is no harm to the rest of the database by letting them change these values)

I have 3 fields in a table: Option1, and Option2, and OptionMix. I want OptionMix = Option1 / Option2. I cannot use a query for because I want the user to be able to change OptionMix once this initial Calculation is Done. In other words, Once this Code is Executed, every Record will have...

I have found a solution to this problem by browsing another forum. The format to use to change the RecordSource of the Subform is: Forms!MainFormName![SubformContainerName].SourceObject = "frmDifferentForm"For my database the proper code was...

Thanks for the reply Bob. When I add the .Form, I get a different Error, it now says The record source 'frmProcessSelectCurrentLSSubform' specified on this form or report does not exist I have tried changing the Name of the child, but I have gotten the same error.

In the following code I am attempting to change the RecordSource of the Subform. I'm getting an error message at the line Me!frmProcessSelectLSSubform.RecordSource = strFormName The Current Name of the Child is frmProcessSelectLSSubform and the Current Source Object is called...

Right, but now my list of queries is very big :eek: and it is going to grow bigger as I add more forms and want to organize information differently! Edit: And well, darn, it seems that another problem has occurred because the totals in my main query are wrong. It thinks that I'm adding up all...

I have solved this issue on my own. The key is to add yet another query containing CurrentID and connect it to the CurrentID in my main query. I get the feeling that Access is just a very strange interconnected tangled web of queries that we keep on making. Strange that subqueries don't have...