Search results

I imported all data into a new table, set up my relationships (1:m from tblAlerts to tblProducts on PK/FK Alert_ID), appended to tblAlerts (parent), and then on my attempt to append to tblProducts I got a key violation. :confused:

So, organize my data in Excel --> Set up tables and relationships in Access --> import into Parent --> import into child. When I am importing, how can I select which columns to append? If my memory serves, it is all or nothing in Excel '07. Unless I choose to import into a new table. Would...

I'm sorry I'm not familiar with adding more than one record at a time through a form/subform.

Ok, I think I understand. I would still be able to add the initial data with an Append query right? As in, I would not have to add the records through the form/subform.

How do I get get my PK from tblAlerts to be a FK in tblProducts? I want the Alert_ID from tblAlerts to automatically populate as Alert_ID foreign key in tblProducts. I've done this before, but I can't re-wrap my head around it. You can't add data to tblProducts without adding it to...

I think I tried that, but I can't remember. Thanks.

When you say recompiling, what exactly do you mean? I tried putting my unsplit accdb file on an offending PC and it still gave an error referencing the Date function, albeit a different error than before.

So, some of the monitors in the office can only go as high as 1024x768 resolution and this prevents some of my Switchboard options from being visible. Is there a way that I could implement a scroll bar in the Detail section of the Switchboard Form that would let them scroll through the options...

Thanks for all the help guys. Today, the query is taking ~ 30 minutes to run, so I don't need the speed boost. My guess is that our system is/was being heavily bogged down as of late.

Yes it is a Year-to-date sales query, so for example if I were to run it today I would need between 01/01/2010 and 04/19/2010 or between 01/01/2011 and 04/19/2011. Here is the SQL: SELECT DWQRYDATA_SLSDSI.STORE_ID, DWDATA_KSSCAT.CATDESC, Sum(DWQRYDATA_SLSDSI.TOTAL_SALES) AS SumOfTOTAL_SALES...

I'm not sure. Would the method that Bob suggested still need to process every record: ?

Yes, it's a very large dataset. I am looking for any ways to increase performance, and the date function seemed like a good place to start. Thanks for the help!

It is a primary key for the table, but no it doesn't appear to be indexed. It's a table linked through ODBC.

Is there a date function that might work more efficiently than what I have here: Between DateAdd("yyyy",-1,DateSerial(Year(Date()),1,1)) And DateAdd("yyyy",-1,Date()-2) Or Between DateSerial(Year(Date()),1,1) And Date()-2 ?

Yes! Worked just fine. Thank you brighton.

I am trying that as I speak!

I suppose it's a single-select. The list-box data source is a simple select query.

So, I found this piece of code online and want to use it in a Report: The difference is that I would like to Highlight Division if it is selected from a Listbox (name?) on a form control. The form control provides a parameter for a query, and the query provides the data for the report. So...

No, it worked fine.

Tried both of these, and same results. I wonder if a reinstall is what's needed..