| Thread | Last Post | Replies |
|
| Delete Custom Database Property | 30 Apr 2008 23:44 GMT | 1 |
Can someone post a snip showing the proper syntax that deletes a custom property on database? I'd post the offending code, but I don't have access to it and I'm a bit rushed at the moment.
|
| Best way to display subset of table information for particular use | 30 Apr 2008 23:37 GMT | 4 |
I have a form that displays information on a particular individual. That individual could have information that details dates and money received on those dates. I am looking on the cleanest approach to displaying this information (in a subform) for that particular user while ...
|
| Need a little advice on frontend setup | 30 Apr 2008 21:53 GMT | 23 |
currently i have a database project where we have a backend that stores all our data and 3 frontends with one reporting "front"end. the frontends are seperated by the type of user that uses them. we have set up a system for international reps to login to a terminal server and use ...
|
| Display non-matching data in a report and don't display matching d | 30 Apr 2008 19:07 GMT | 4 |
Hello, Pros, Basically, listed below is a report that I'm doing. This is a small sample of the report that will have over 400 fields, 200+ on the DB2 DATA side and 200+ on the SAP DATA side. It will show the field name, followed by the data,
|
| Format text when export data from Access to Excel | 30 Apr 2008 18:12 GMT | 2 |
In the following code, data is dumped from query result to an Excel file, starting at cell a4. My problem is the data in the first column from my query results . Even though they are all text data (however, numeric in nature), Excel will change them to numeric. For example, ...
|
| Importing Excel Spreadsheet based on date in Form | 30 Apr 2008 16:55 GMT | 8 |
I am trying to import a particular Excel Spreadsheet based on a date setup on a form. I am trying to use an if-then-else statement and it continues to bomb. If I just use on statement it works but if I try to add an Else statment it doesn't. Any suggestions.
|
| ADO - Access Undefined function | 30 Apr 2008 14:37 GMT | 2 |
I am using ADO in and MS Excell Code module / Macro to run some select queries that exist in an access database. The access query that I am running uses a custom function named fFindVendorName that exists in a code module in the access database file.
|
| List Box Problems - OnClick/AfterUpdate Does Not Change Value | 30 Apr 2008 13:29 GMT | 5 |
Here's the deal, I've buildt my own custom wizard. On one of the pages, I have a list box that controls the record source for a subform on the page. The idea is that as the user selects different values in the list box, the subform displays
|
| Function to check if linked tables are attached | 30 Apr 2008 13:27 GMT | 2 |
Anyone have some code that tests if linked tables are currently attached?
|
| Type mismatch | 30 Apr 2008 12:31 GMT | 1 |
Sorry if this is obvious but have now spent hours playing around with no joy. Keep getting a type mismatch error with this code. I have DAO as a reference, but not ADO. I have tried setting both as reference s and then just using ADO but then the Dim dbs As Database and Dim qdf As ...
|
| Import .dbf files to MS ACCESS | 30 Apr 2008 12:00 GMT | 5 |
I am trying to bulk import .dbf files into access. The numbers change every time a transaction is input, but the first two positions stay constant. For instance: QB00331, QB00451.
|
| DoCmd Sometimes does not appear to work | 30 Apr 2008 11:52 GMT | 7 |
I have a very strange symptom occuring. I am developing and testing a Client Management Database, and for some reason. One of the "DoCmd.Openform" lines I am using does not appear to work, when placed the Front End database, is installed on to the machine that it will be ...
|
| Make list available dependent on selection of another field | 30 Apr 2008 09:52 GMT | 1 |
Hi again! I have a list of reasons which the user must select on an input screen (form). There are however reasons in this list pertaining to a departmental option of another field. Is it possible to make certain values in this list
|
| Select record on second subform | 30 Apr 2008 09:47 GMT | 1 |
I have two subforms on my main form on different page tabs. When I select a record (by clicking on it) on the subform on the first page, I would like it to select the same record (put the arrow next to the record in the datasheet subform view) on the second page. Is it possible ...
|
| Open an Outlook folder | 30 Apr 2008 06:20 GMT | 1 |
Hi, I tried posting this questino earlier but I think it was kind of confusing, so I want to post it again: Is there a way to open an outlook contact folder of a specific name, rather than the default contact folder, or rather than using the pickfolder method?
|