| Thread | Last Post | Replies |
|
| File Security | 01 May 2008 00:52 GMT | 1 |
I have a split secured db on a server. The user has the front-end on their local pc and the back-end and security file are located on the server. What minimum priviledges does one need to be able to run the database properly?
|
| Using the count function with a condition in an Access Report | 01 May 2008 00:46 GMT | 6 |
I have an access report pulling information from a query. One of the fields is “PHD” and it has values “yes”, “No” & “N/A”. I understand that I can use “=count ([PHD])” in a text box to count the total number of people with PHDs but is it possible for me to only count the ...
|
| Table Comparison Question | 01 May 2008 00:43 GMT | 3 |
I have two tables. Both tables contain a unique set of numbers that identify a product. How do I compare the two tables to see which items from one table are not included in the other table. Feel free to email me @ nlayman561@yahoo.com. Thank you.
|
| Export always witha different name | 01 May 2008 00:30 GMT | 4 |
I need to export a query to a txt but always with a different name. Imagine. I now I'll export with the following name: FA0000000001.txt the next time all need to export with the name of FA0000000002.txt.
|
| Can't find error | 01 May 2008 00:28 GMT | 2 |
On a form I want to open another form with the relevant information from the selected information in a subform. When I run the code I get an error saying it can't find the field 'Top10failingComponetes subform' referred to in your expression.
|
| Multipule Filter on a Form | 30 Apr 2008 22:21 GMT | 11 |
I have a form that I would like to use a Combo box to filter off of. I have never used the filter option in the form before. How do I structure the filter to look at the (2) combo boxes to pull the certain record(s)? CmboSalesRep
|
| Trusted Locations | 30 Apr 2008 22:19 GMT | 1 |
I know I can set the trusted locations to add network folders, but my functions still do not run unless I manually check to "allow trusted locations on my network" checkbox. I would have to do that for every user that opens a database.
|
| Small Macro Help | 30 Apr 2008 21:44 GMT | 1 |
I have no idea of writing or recording Macro in Access. I am browsing a database where I copy info from 1 cell to another another cell Since I have to do multiple times, I thought a Macro would help.
|
| Text vs Numeric error | 30 Apr 2008 21:41 GMT | 3 |
I copied over a form that someone else had created for a different database for a different vendor. When I try and run the form I get a Data Type Mismatch In Criteria Type error. I noticed that the UPCCase field's Date Type is a Text on the Master Table in the original database ...
|
| Command Button to run a query that updates a report to preview | 30 Apr 2008 21:19 GMT | 2 |
Hello all! I'd like to thank all of you that are helping guys like me get ahead in Access. I was wondering if there was a way that I could create a Command Button that will first run an update table query and once that query has successfully run, I would like for this command ...
|
| Novice to splitting | 30 Apr 2008 21:19 GMT | 3 |
My question(s) will sound silly but I am new to the splitting concept. I put the database on the shared drive and then and went through the Split Wizard where it created the export_be.mdb on the shared drive and the other export.mdb (which I am assuming is the front end).
|
| Can I eliminate the Yes/No Append message box? | 30 Apr 2008 20:45 GMT | 4 |
I have a button that adds a new record to a table (see code below). Of course, before doing it, a message box pops up telling me I am about to append 1 row(s) with a yes no button. Is there a way to code the button, so that the Yes/No message box does
|
| Too Many Tables in Form Query? | 30 Apr 2008 20:32 GMT | 5 |
I am somewhat new to Access and am working on a form for a doctor that will be used to gather patient data. There are three linked tables: Patients, Visits, and PatientAddresses. Patients.PatientID (primary key) is related to Visits.v_PatientID foreign key. This has worked
|
| Automatically populate fields in my forms | 30 Apr 2008 19:35 GMT | 2 |
If I have a customers table with SSN for key field and I have an order table with SSN for the joining field, how can I go to the order form, put in the SSN and get the first and last name to automatically populate for me? Thanks!
|
| Toolbar Positioning | 30 Apr 2008 19:10 GMT | 1 |
Why is it, when I arrange my toolbars (the standard ones) in Access 2003, they don't stay put!!! This drives me crazy! If I switch from design view to form view, they are no longer where I put them. Is there a way to lock them in place?
|