Search results

My tables are not set up that way, it's the queries that I have to create that way. The database is much more complicated than just calculating a one-time price. I have to be able to show the individual savings on a project for every single month from the effective date on. Each month will be...

Myself and my manager are really the only ones who use the db, so if it is the more correct way to do it, I will make this change. Thanks for all of your help.

Thanks. Due to other change requests, I need to basically re-write my database anyway, would it be easier, smarter to just change my field names to read 1/1/06, 2/1/06, etc instead of having the Month and Year text fields?

You might try placing the criteria for the "Date" field in the next criteria field below it.

I created the table as suggested and was able to create my query to show the monthly amounts for every project in my database. I now need to be able to do some kind of Date function to allow the user to select a range of months to view. I think I'm going to run into problems since I'm not...

Thanks for the help, I will try your solution.

So are you saying that I should alter my table and have my product names as my fields and the records/rows as the month/years? Each time I add a new product I would have to add a field to my table. Now Product Year Jan Feb Mar Apr May... Suggestion (?) Month Year Prod1 Prod2 Prod3 Prod4...

I'm looking for a starting point for this query. I currently have a table "tblMonth" with the fields: product, year and each month (Jan, Feb, Mar, Apr, etc.) I enter month volumes into this table which is used to calculate savings amounts. Currently I create queries that show the month data...

Pat, The subform automatically appears when the main form is opened. In the "Form_Load" event I have "DoCmd.GoToRecord , , acNewRec". Should I try to have the subform stay closed until the "After Update" event of the Employee name combo box? If I change it to "Data Entry" only won't that...

I have a form with a drop down of employee names and a tabbed subform. I have the form and subform set up to open on a new record and, when the employee name is selected to fill the subform with that employee's data. It is a split db with the be on the network server and everyone has their own...

Distribute dll file I just created a .exe file with my FE .mdb and MouseHook.dll. I have it set to download and extract to my users C:\Training Database folder. I originally did not place the dll in the folder and my users were getting an error message that the dll file was not found. The...

Distribut FE Finally getting back to this. I created a .exe file from my front end, set it to extract to C:\Training Records on everyone's system, and placed the .exe on my website for everyone to download it from. I think this is the right way to do this but would appreciate it if anyone...

I have an Access 2000 database with the BE on a network and the FE on individual computers. We have recently gone to Office 2003 but I have kept both version of Access on my system as well as leaving the db in 2000. I have a form with a drop down list of queries to select from (queries are in...

Not getting an error message on this one (the "short" version of the code) but nothing happens at all. When I try to run the one in my first post I get a message "Item not found in this collection". I've verified the table names in both FE and BE and can't figure out what the problem is. I've...

Wayne, Thanks for the code - could you please clarify a couple of things for me? This looks like you have the code in a form (Me.txtServerName). Set tdf = dbs.TableDefs("tblODBCDataSources") tdf.Connect = "Driver={SQL Server};" & _ "Server=" & Me.txtServerName & ";" & _...

I got this code from the MS Knowledge Base. I have a SQL back end and an Access front end. I need to zip the FE and email it to the users. I discovered that I needed to created a DSN on each user's machine to link the SQL tables and am trying to use this code to automate it. I am getting a...

I have a split db with the backend on a shared drive. I have two combo boxes on my form that are filled with a sql statement from two different tables - one is "manager" and one is "owner". When I open the front end on my system both combos are loaded with the correct data. Lately when I open...

Thanks RuralGuy - another thing I've learned here! Toni

Thanks for the reply. This makes too many " and then comments out the line after the ' strWhere = strWhere & " (tblContracts.preparer) = " '" & Me.cboOwner & "'" I also tried to add another " after strWhere & " which caused the same error message. Thanks, Toni

I am getting a Missing Operator message when running this from a command button on my form. stDocName = "OpenContracts" strWhere = "WHERE tblContracts.closed = False AND" strWhere = strWhere & " (tblContracts.preparer) = '" & Me.cboOwner & "' AND" Have also tried stDocName = "OpenContracts"...