Recent content by cani

I had a similar problem with field summmation which I resolved with user-defined functions. In most cases, I used in-line UDFs to return a recordset, and tested to see whether there was a recordcount. If so, I moved to the first record (which would be the summation, and assigned the value to...

I would guess some DAO would work, but Microsoft appear to be moving away from DAO in favor of ADO in Access Projects. Much of the DAO code that I used in my mdb files have had to be replaced with ADO before they would work in my adp files.

I still don't know how to do the above, but I did resolve my problem. If Access is closed while any form control's properies box is open then the next time Access is opened (even if another database) the properties box for a control that has focus will open. I opened the properties box of a...

I still don't know how to do the above, but I did resolve my problem. If Access is closed while any form control's properies box is open then the next time Access is opened (even if another database) the properties box for a control that has focus will open. I opened the properties box of a...

I locked myself out of the design view of my database, and need to be able to get back With my limited Access Project knowledge, I believe my options are (1) bypass startup options to turn on full menus so I can get to the design view or (2)create another database and import the forms and...

Thanks, Rick. I tried the code. I set a reference to DAO 3.6 library. I received an error message "unrecognizable database format". I'm assuming because the code is looking for an mdb file format, but the file I need to connect to is an Access Project (adp file format). I suppose...

Does anyone know how to send a password to the VBE of another Access Project? I mistakenly locked the design through the startup properties. I have also disabled the shift bypass. To get around it, I've created a new Access Project and wish to import the forms. If another method would...

I want to prevent users from getting to the database Window in an ADP file. I'm hiding the Window, disabling the toolbars, etc., and disabling the shift key; however, (although no user has figured it out yet) the main weakness is with reports. I am displaying a custom tool bar to enable...

Help! I need to assign a recordset to an MS Access Project form. The recordset is based on a SQL function that seeks an input parameter to return one record. The objective is to return a record from SQL Srv 2000 that has a company name (key field) that is equivalent to a value selected from a...

Good day! Does anyone know how to do one of the following: 1) Use SQL to hide a table so that it does not appear in the database window 2) Use DAO to hide a table; or 3) Adjust a database setting so that all forms, tables, macros, reports, etc., that are created have the hide property...

It is difficult without knowing the format of the report/form you are trying to create, but I would imagine that the various fields have unique values (i.e. "m" for male, "f" for female, "w" for white, etc.). Have you used the natural grouping in reports or used...

Not sure how complicated you want it. I would imagine you are combining them in a separate fields say "mainauthor"/"rest" [mainauthor] = [fname1] & " " & [lastname] [rest] = ..... following the same convention as above. Or declaring a variable as a string Dim...

I do not have too much experience with programming so this may be a long way around it. On the Load property event of the form, I would use code that loops through the attached recordset (beginning at the first record and moving through to EOF) using the Edit and Update commands to transfer the...

Thanks, Junior. "Microsoft DAO 3.6 Object Library" is currently the 3rd item on the list below "Visual Basic For Appications", and "Microsoft Access 10.0 Object Library". "Microsoft ADO Ext 2.5 for DDL and Security" is number 5 on the list. Any other...

Hello, I had an access (mdb file) 97 database that used code to assign security permissions to a table for a particular group. It worked fine (the code is below). I then upgraded to Office XP and the file was converted into 2000 file format. The procedure stopped working. Now I get the...