Search results

I am importing data from Excel formatted like this: Product 4/1/2008 5/1/2008 6/1/2008 7/1/2008 8/1/2008 8500 3200 500 2500 1050 3000 My table in Access is formatted like this: product monthdate volume 8500 4/1/2008 3200 8500 5/1/2008 500...

Wondering if this is possible. I'm trying to clean-up my db and have about 8 separate SELECT queries that I am running from a macro and exporting to Excel. Can I create a module with all of these queries so I can delete the 8 separate ones? Thanks

I have the following code attached to a submit button on my form with just one unbound field "projectid". I need to add an error message when the projectid entered does not exist in the database. What I have tried is not working so far and would appreciate some help with the code. Private Sub...

Tried several suggestions in the forum but haven't found one to match my needs. I have one table, Jupiter and need to use this query SELECT Jupiter.codename AS Build, Count(Jupiter.tooling_ind) AS [# Needing Tool], Count(IIf([tool_req_type]='OR',([requisition_no]))) AS [# Tooled], [#...

Need some help with this one: I have a "build a query form" with five listboxes. The last one is a list of suppliers. I have the code set to pull the records for only the supplier that is selected or, if nothing is selected, pull all of the records. The problem is that some records do not...

I have a form with a combo box with the recordsource of: SELECT [SubType].[SubTypeID], [SubType].[SubType] FROM SubType; I have a delete record button: Private Sub delete_Click() Dim strInput As String Dim strMsg As String DoCmd.SetWarnings False Beep strMsg = "This action...

I have a table with the following fields: planned_volume, actual_volume and monthdate. I need to come up with a query that will sum the volumes based on monthdate, like: (fieldname)1/1/2007 - If monthdate = 1/1/2007 then SUM "planned_volume" where "monthdate" betweeen 1/1/2007 And...

This may have already been addressed, but I can't even think of how to word it to do a good search. I have one table, tblInvoices. I've done a query to search for "Micro*" in my [supplier] field, along with [Item]. I then need to pull from the same tblInvoices, any other records that...

I was working in my database and suddenly started getting this message on every button I clicked and on advancing records in my form: "The expression "On Click" or "On Current" or "On Load", etc. you entered as the event property setting produced the following error: Procedure declaration does...

Could someone please point out what could be wrong with this code? I have a form with txtCutInDate and txtEndDate. I am trying to do a DSum from a query to calculate a volume based on between the two dates and place that volume in the [prodvolume] field, i.e. if my cut in date is 5/1/2007 I...

Have been unable to find any solutions for this in the forum or the help files in Access. Project has a [cutindate] and an [enddate]. A [flatamount] ($$ savings amount]. I am calculating the month savings by dividing the [flatamount] by the number of months between [cutindate] and [enddate]...

Looked through DateSerial but possibly not the way to go. I have a text field, "Month", with the dates in this format: Jan-06, Feb-06. What do I use to convert these to date format? 1/1/06, 2/1/06. Thanks Toni

Can't seem to locate a similar situation in the forum for this problem. I have a form based on "qryProjects". I have another form "Menu" which has cboType, lstStatus and lstSubtype. I thought that I could select criteria from each and, with a command button, have the form open up filtered...

If there's a post out there that addresses this, please point me in that direction as I've had no luck. I have my queries listed in a table. On my form I have them listed in my combo box. The user selects the query they want and hits the command button "Run". I would like to show the...

Has anyone experienced this error message before? "Could not use "V:\Project\Materials\PurchSQE\Training\MaterialsTraining_be.mdb';file already in use". Backend is on a shared network drive and everyone has their own copy of the front end. I installed the fe on several machines, but, on two...

Can this be done? I have a single $ amount and an effective date. I need to take that dollar amount and disperse it out evenly over 12 months. Is it possible to create a query that will create the fields 1/1/2006, 2/1/2006 and enter those amounts? For example, total savings is $12k and...

Does anyone know why this is not working for me? I am trying to change a query to add additional criteria and the records that I am trying to exclude keep showing up. Original query Field - "otherloc" Criteria - <>"Supplies forecast" Or Is Null New Criteria - <>"Supplies forecast" Or Is Null...

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...

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...

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...