Search results

In access we are using an ODBC connection to an Oracle Database. But we cannot insert new rows into a table. The DBA here says it's not an Oracle Issue becauase we have full permissions on the table. How to change the security in Access? (If this is actually the problem.) TIA

What do you reccomend using to graphically document the relationships between Access tables or does Access have a tool that I am not aware of??

I have a report that has a subtotal based on the Agent group field. Sometimes there are 5 or 6 Agent Codes within the Agent Group so I need to do a subtotal for the entire Group. However sometimes there is only 1 Agent Code. Is there a way to not show the subtotal if there is only Agent Code...

I have 4 Endorsement fields in the primary table because a policy can have up to 4 Endorsements on it. On the Form there are 4 Endorsement fields and the user selects from a drop down box the endorsements that apply. The drop down box for each of the fields is the same. Currently the fields...

Is there a way to get a list of all the queries that contain a certain field? TIA Val

I have 1 user who runs a query once a week and prints it. Last week for the first time the query printed without the gridbox. The grid shows in print preview. When the query is printed from any other PC the grid prints. I have checked the settings in Tools, OPtions, Datasheet on her PC and...

I used the label wizard to create a report to print labels. This report is based on a query. When I run the query by itself there are 16 rows selected. When I print the labels only 10 print out, Which is the number of labels on 1 page. Even when I run the report in print preview I can't see...

Does anyone know where I can take a look at a database(s) with some switchbaord examples. I am trying to design one now and I want it to be really impressive, but it just looks blah. I'm looking for ideas to dress it up a bit. TIA, Val

I have a report that gives me state and then line information. In the state footer I am doing a total for all lines within the state. How do I do a total for all states by line?? EX: State 1 Line 1 State 1 Line 2 TOtal State 1 State 2 Line 1 State 2 Line 2 Total State 2 Total All States...

I am trying create a command button that will open a subform based on the criteria in either the name or the ID field. The premise being that the user usually knows 1 or the other but not both.

How can I create some sort of a timer to show how long a macro has been running? Thanks in Advance

Is there a way to have group Header appear before the Page Header? I have a report and the group header gives the title and date for the report and I want to use the page header for the column names, but now the column names appear above the Title.

For quite a long time I used a scheduler to Open access, run the autoexec macro and then using the /X run an additional macro. The update was done every morning and I had no problems. Then there were some changes in the office, I got a new PC and had some problems with congigurations Etc...

I have a report that has 4 sub-reports in it. When the report is run there may or may no be data for any of the 4 sub-reports. How do I print a message that says "No data at this time" for any of the sub-reports that have no data, but still print the ones that do? The report has to include a...

I realize that this question was already asked and answered, however the database I am having a problem with is still Access 7.0. Database Form is not fully viewable on 14" monitors as it is on 17". Is there any way that I can set the size of the image of the form to tell what size...