Search results

Help, I have a form that i want to filter. I've got a table called filters that i want to load from a table called filters into a listbox. (attached- please view) when the user clicks that row, i want that filter to be applied. eventually, if i can figure this out, I would like an independent...

I am new to Access... just updated to SQL server and the company is really on me to get this database in shape. Anyhow, enough crying... here is what i am trying to do. I have a common table called 'main' that i tend to filter a lot manually to manipulate data. What i would like is a...

Please take a look at my screenshot. What i am trying to do is this: the form 'A' is my main interface. I have several Subforms that pull associated data from the grouping table, then write to the groupingID table. Each of my Subforms pull filtered data from the grouping table. for example...

Please suggest any overall db design issues that you might see visually with my db. Is using sku as the primary key, or should i just use an autonumber field?

I have a table with a bunch of different movies, Some items are available in dvd, vhs, or pal formatting. each one of these items is keyed fairly consistantly in the database structure via a FormatID field and an indication in the sku itself. an example of how they are keyed: SKU - sk756...

I have a report that i want to include only a select few titles that have a SportID name "skate" but that only falls within a certain sku range or value.... what would the syntax of this be? you can see my really bad attemp below: this is the SportID Criteria field... I dont want all skate...

hello. I have a Design Master and apprx. 10 replicas that are all stored in the location on our server locally here at my business. Because I have so many replicas, I find myself spending a lot of time synchronizing all of my changes with my created replicas. Is there a faster way to do...

How could i make a 'Filter by Selection' that i could tie generically to a state of a field in a form. For Example the sportID on a particular record, having an ondoubleclick event that would run a filter to only show the records that have that sportID. Thanks.

i have my design master so that it opens hiding the tables / queries / macros / ect.... Also my tool set is set to basic and i can't synchronize because i can't see my tools drop down menu. how do i get these back ? this is what i would like them this way so that when i synchronize with...

because of a problem with access cutting off memo fields after 255 characters, a user in this group made this script for me to solve the problem. I saved it as a module called Excel256_fix and then try to run it i get an error this says "compile error, cant find module or library" I searched...

:confused: :confused: :confused: I am trying to take duplicate information and combine it together into on single value seperated by spaces or commas. I haven't quite grappled the concept of a totals query. It seems like this is what i need but instead of a total number of occurances, i want...

hello, i am not too hot with coding but this should not be too hard so if someone could help me i would greatly appreciate it. Here is what i am trying to do: I have an items description divided into several parts all of which i combine later for use: Copy [memo] Atheletes...

Hello, i have a report in which the information is grouped several ways: 1st level - Category 2nd level - Sport 3rd level - Producer 4th level - Release I want to supress the Producer Group unless the producer occurs more than "x times" so that the report doesn't generate group headers for...

All i want to do is to make my Release field a different color if it is new than a certain date.... I have used Conditional Formatting for fields that are common ( formats >>> V, or D, ect. but i dont understand how to use Conditional formatting for a date range I've tried this: >06/01/02 in...

Hello everyone. I have a table in which i have seperated out different elements of a description for each item that i have in my database. For convenience, i've made an additional field (non editable) which combines all fields together for simple copy paste abilities out of the database: This...

Hello everyone. This is probably a fairly uncommon question. I work in a Mac/PC work environment and would like to know if anyone has come up with a solution to allow for Mac users to see the underlying Access tables. I know that MacOffice doesn't include Access but that you can can ODBC...

I would like to make a "filter" to generate a table / query / or a form that contains values from multiple space or comma delimited entries. any input / ideas on how to make this "filter" the simpler the better / The values of my filter would be SKU so i would copy a series of cells from...

Hello. I have database that i need to append information from a spreadsheet. What is the most straightforward way of doing this The spreadsheet has some primary keys that are not in the Access db yet, but for now i just want it to skip these and append the existing matches with the new...

I get a message stating that i have too many fields defined in my table. I even tried to rename an existing value in that table but i still get this message. What is causing this ? Help

I have to close out Access entirly for Queries and Reports to close I recieved a message saying that i was refrencing the same thing 2 times in the code for that query. As a solution (not a very good one at that) i deleted all of the VBA that was created when i used wizards to create buttons...