Recent content by thart21

Thanks, I'll give it a shot.

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

That's what I meant, sorry I wasn't clear on that. I do want to create all of the queries within the module, just wasn't sure if it was doable or even made sense. Thanks!

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

Thanks so much, works perfectly!!! Private Sub Command3_Click() If DCount("[projectid]", "tblProjectDetails", "[projectid]=" & Me!projectid) > 0 Then strWhere = " (tblProjectDetails.projectid) = " & Me.projectid DoCmd.OpenForm "Projects", , , strWhere Else MsgBox "Item doesn't exist" End If...

Thanks for the quick responses. Is the DCount going to take care of the user entering an incorrect projectid#? It looks like it's just going to look for a number in the field (>0) but perhaps I am reading it incorrectly. 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...

The grouping by "codename" is what Access did automatically from the query grid and that is working fine. I'm trying to eliminate duplicate part numbers from the query. I think I am going to need to create a new table using "DISTINCT" to eliminate duplicate part numbers within each "codename"...

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

Thanks for the explanation, that makes sense to me now. I knew when it happened, just not why, now I know:)

Figured it out, I think. I had created an AfterUpdate event on a control, then changed it in the VBA window to BeforeUpdate. I think that confused it and I ended up having to delete the control, remove the datasource from the entire form, save it and add the data source again. Then...