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

The way that I delete duplicates is to copy the structure only of the table and then set the primary key so that no duplicates are allowed. Then I append the data from the old table to the new table. There may be an easier way but this always works for me! HTH Val

Nope - not counting spies! Just Insurance Agents. (Sometimes I'm not sure which is worse) Thanks for the Suggestions - I got it to work. I created a field in the Agent Group Footer which is where my subtotals are to count the number of Agents in the group. Then I used the following...

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

Thanks for your reply Doc_Man. I realize that the data is not properly normalized, but I inherited this database after it was in existance for a while and at the time it seemed easier to leave it alone then to start over. (Now I'm not as sure!) I tried what you suggested and while it does...

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

Genevx: Can you use the Find Unmatched Query Wizard to give you all the records that don't match? Val

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

Ryan- Yes it will, for the most part the initial installation of Access 2000 took care of it. We only had to manually add to a couple of PCs. Val

If you look in help in access 2000 there is a specifc .dll that is required to support the IsOdd function. I think it is msowcf.dll, not sure though. Hope this helps! Val

Add a AutoNumber field to the table and then use Rnd([AutoNumber_field]+1), this has worked for me. HTH Val

I thought about using word also but I was trying to keep it simple. Thanks for the help. Val

Ah, if only it were that simple. It's very strange, there are 10 labels per column and there are 2 columns on each page. We have to print 2 different labels for each policy, so I set it up so that the labels for each policy are next to each other. Basically we have 1 row per policy. When I...

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

Try putting " around the datepart. EX "wwww".

I had to do something very similar and talismanic was good enough to point me in this direction. Hope it works for you to. This will send the table as a text file. Docmd.SendObject actable, "Table Name", "Ms-DOSText(*.txt)", "E-mail Address",,,,False

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

Just for the record I've done nested iif statements with 5-6 conditions and had them work successfully. Anything above that I would suggest writing a case statement for. Jatfill is right, the best thing to do would be to post your statement.