| Thread | Last Post | Replies |
|
| Need help with a VB script for a command button in Access 2003 | 24 May 2008 17:43 GMT | 1 |
I’m having a little problem… Using MS Access 2003: I need to build an event for a Command Button, but I’m not VB savvy at all. I’ll try to make it as literal as possible.
|
| Log to show last time/date opened | 24 May 2008 14:23 GMT | 3 |
I am trying to come up with a solution that will allow me to show in a text box on my main form in my Access 2003 database when the last time/date the form was opened. Every Friday I want the database to auto email a report
|
| How can I close access in vba code? | 24 May 2008 13:34 GMT | 12 |
I have a macro that is schedule to run every day to copy a database. However, when I execute the macro it does not allow me to close access. Access is open to execute the macro but would like to close it automatically (as part of this macro). I added a QUIT macro but give me an ...
|
| VBA broken in Access 2003 after installing Access 2007? | 24 May 2008 13:04 GMT | 8 |
After installing Access 2007, some of my Visual Basic procedures don't appear to work any more in Access 2003. These are in mdb files that have never been opened in Access 2007. The particular error message I am getting is "Run-time error '459':
|
| looping through comma delimited text | 24 May 2008 06:49 GMT | 1 |
Hi I need to do something with a comma delimited block of text . ....like text , text, text, etc
|
| Iff Statement Question | 24 May 2008 06:48 GMT | 3 |
I'm trying to use the following 'Iff' statement and it's not working out for me. Iff(([tblCrew_Event_Matching]![Event]=Yes),([tblCrew_Event_Matching].[Event/Room])=[Forms]![frm All Events]![Event Name],([tblCrew_Event_Matching].[Event/Room])=[Forms]![frm
|
| Open a PDF | 23 May 2008 23:40 GMT | 2 |
Access 2007. Need to be able to open a (different) pdf from a form in Access. Have written a procedure for the On Double Click of the appropriate control, but need the command line to open a pdf located on the hard drive. I thought the command was "Call" but could not find ...
|
| Appending Excel Files to Access | 23 May 2008 21:44 GMT | 1 |
Hi I am currently learning to use Access for my work and have been reading a few books to learn the basis functions. However, I am trying to get someone to help me with VBA... I am hoping to append data to a table from excel automaically, I have
|
| vba - fields in forms | 23 May 2008 16:25 GMT | 2 |
Hello. How can i read the contents of a field, in a ACCESS form, whose name is txt1 and its placed in its fifth (of 20) line. Thanks
|
| How to Set Colors on TabPage? | 23 May 2008 15:56 GMT | 1 |
How to Set Colors on TabPage? Hello, I'm using Access 2003. I've designed a small app that has 2 pages. Page 1 has basic info and has a button that links to page 2. On page 2 I set up a TabControl with 4 tabs. I have changed the backcolor of the form and now trying to change the ...
|
| unrecognized database format | 23 May 2008 13:19 GMT | 1 |
I just converted a word template that was created in Word 2003 to a Word template in version 2007, so it has become a dotx file. The template contains a macro that runs a VBA routine that reads data from an access accdb file (2007).
|
| How to hide the menubar in Access 2007 | 23 May 2008 10:36 GMT | 4 |
I ve got som problem. Do someone know how to hide the menubar in form login form? When Iam trying to come to the database I continuesly see the menubar in the west side. And if click on it I can skip the login form and can come in without password and username.
|
| Problem with VBScript to open a database | 23 May 2008 08:18 GMT | 1 |
I have a database with Autoexec Macro in it (which would run when a user opens the DB) I dont want to open that particular DB manually. So I have a script that would open the DB and the macro will run (macro just creates a copy of a certain table with a date appended to the name ...
|
| Switching databases | 23 May 2008 07:10 GMT | 1 |
I won't to be able to switch from one database to another using VB. I was relatively happy using SendKeys but, having installed Access2007, now find this fails. I've yet again looked at RunCommand acCmdOpenDatabase to no avail, just get
|
| How to Call a Function | 23 May 2008 00:46 GMT | 4 |
I trying to run a function, but can’t quite figure out how to call it. The Access Bible says that you have to add a function call to the Control Source of a control, but I’m not sure how to do that. I guess the example in the book used a Form to call the function. Do I need to ...
|