Search results

this is the databases structure... the backend holds the table data. but the front end stuff is what is replicated.... no tables are replicated only forms and queries

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.

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

contents is the field name in the form that has the onclick action to start the macro

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

GREAT... Thank you so much.... i am not sure what a 'public function is' but i will try to tackle this..... thank you again >>> I was beginning to think that the overall design of my database was faulty and began to think that i should have built the database to hold this information...

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

It does, but when i enter >#06/01/02# into the Conditional formatting field nothing happens on 2k Office. Strange, it doesn't give any error messages just doesn't display the formatting.

This works great with Office XP edition but not on Office 2000 edition Is there a way to do this without conditional formatting so that i can get it to work in Office 2k ? ?

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

hmmm.... not really what i am looking for. If you look at my attached image .... you can see that as you look through items there are seperated fields for entry but then "DescriptionAll" combines that same information together for copy paste opportunities.... I dont think a paramater query...

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

never mind... i found it ... Thank You