| Thread | Last Post | Replies |
|
| Trying to add second row data | 10 Jan 2006 23:39 GMT | 1 |
I have the following code...the first record is added in the table but not the second.. What is wrong? With rsNewData
|
| Changing Chart Data Series | 10 Jan 2006 23:06 GMT | 1 |
Is is possible to change a chart's series color with vba code?
|
| Switchboard Hyperlink Problem | 10 Jan 2006 22:59 GMT | 5 |
I have a standard switchboard that I created with the Switchboard Manager. One of the buttons I have on it is supposed to be a hyperlink to another database. I tried to create it by choosing the command "Run Code" in the Switchboard Item box, and typed the function name ...
|
| Enumerate records in Access Query | 10 Jan 2006 22:41 GMT | 5 |
Unsure if this is the right forum... apologies if it isn't.
|
| OpenRecordset - Run-time error '13' | 10 Jan 2006 22:28 GMT | 3 |
With reference to Microsoft DAO 3.6 Object Library and the following code Dim dbs As Database Dim rst As Recordset Set dbs = CurrentDb
|
| How do I view cd's for my online class in Windows 2000 Profession | 10 Jan 2006 22:10 GMT | 1 |
I have Windows 2000 Professional. IE 6.0. Taking online course Introd. Computer Information Systems. The cd's that come with I cannot register because only get the top half of the instruction page. Cannot scroll down to enter the registration code. Told my pc needs be ...
|
| Move command using Shell in Access VBA | 10 Jan 2006 21:02 GMT | 7 |
I am trying to execute a move command in VBA for Access using the Shell function. The code I'm using is as follows: x = Shell("""MOVE ""P:\Field Audits\FAT\CompletedAudits\*.xls"" ""P:\Field Audits\FAT\UploadedAudits\""")
|
| calling a function from a sub | 10 Jan 2006 20:49 GMT | 8 |
I have a Private sub activated by the OnClick event of a forms command button. The code within this sub adds records to a table. I have borrowed some Function code from Allen Browne MVP that deletes
|
| Looking at properties of a file | 10 Jan 2006 20:13 GMT | 1 |
I have a trigger program (access) that monitors a folder. When a file is in this folder I do some processing with the data then move the file. My problem is, if the file has no data I would like to not do anything with it.
|
| Unduplication headache | 10 Jan 2006 19:40 GMT | 4 |
This really is giving me a headache. Maybe the answer is obvious but I've been bending my brain around this one for three days. I need to come up with an unduplicated list (for mailing labels) of clients in groups CW, FS and MC. The problem is, a client can be in one, two or all ...
|
| IIf failing:Control can't be edited, it's bound to the expression | 10 Jan 2006 19:16 GMT | 4 |
IIf stmt: =IIf([BuildingPermit]>0,[Forms]![Building Permits]![Owner],Null) Goal: Automatically complete fields if tied to record on the "one side," and to allow new information to be entered if not tied to another record. Automaticall fills in successfully, but will not allow ...
|
| Obtain Field Properties | 10 Jan 2006 17:52 GMT | 7 |
I am trying to find out how big (long) each field in a data base is defined to be. i have used the following: cntr1 = DBEngine.Workspaces(0).Databases(0).TableDefs(0). with attributes, record count, properties, and fields as the next word. Attributes returns '2'.
|
| module and microsoft mailmerge | 10 Jan 2006 17:34 GMT | 1 |
Hello. I have narrowed my problem down to my modules that are used in queries in my database. my problem is that when I perform a mailmerge to a word document the modules used seem to freeze-up the mailmerge. the modules are used to summarize multiple records fields into a ...
|
| sample code to create and drop a link to an external DB table. | 10 Jan 2006 17:23 GMT | 6 |
In order to prevent someone from opening the FE DB (by using the Shift key technique) and changing data in a linked table, I would like to set up the link in code when the FE is opened and drop the links when the FE is closed. I have not been able to find how to do this in VBA.
|
| How to set table descriptions in vba | 10 Jan 2006 16:58 GMT | 3 |
I have created a table that has 2 columns (name, description) which list table names and descriptions. What i would like to do, is after certain tables are destroyed and recreated, I would like to add the stored description to all tables.
|