Search results

I have developed an Access mdb file with lots of tables, forms, queries, reports, and VBA code. I want to be able to distribute this to Access-less users. I understand that the Access Developer Extensions enable this to be done and that the two wizards assist. My first question is this: Are...

Ok, here's what I am trying to do: I have one mdb with lots of tables, forms, reports, VBA, and macros. Two people in two cities will each get a copy; each will populate data. At some point, User2 will export data and send it to User1 for import into User1's copy. Likewise, User1 may send a...

Using VBA, tied to a form button, I'd like to open an email note with a file as an attachment. i can open the note, insert an address, insert a subject, and insert message text, but cannot figure out how to add the attachment. I'm currently using DoCmd.SendObject to create the message and add...

How do I simply create an mdb file using code? I want to use a transferdatabase command to export data to a table (for import at another time), but this expects a file to exist already. I've searched with no useful example - perhaps I've missed it, if so, please point in the right direction...

So, it seems both outputto and transferdatabase both write to an Excel file just fine, but is there any way to write table data to a new worksheet within an existing workbook? I want to save several tables to the same Excel file, but am not seeing clearly how to do this. Is it even possible...

I have built a rather extensive database using Access 2000. When I install it on an Access 2003-enabled machine, the first time it is opened, the user is presented with the following errorbox: "An error occurred and this feature is no longer functioning properly. Would you like to repair this...

Hello, I would like to issue a system command from within a VBA function. Specifically, I'd like to start another application using a command-line startup command, but am not sure how to do that. Any suggestions? Tom

Hello. I currently have an Access mdb with all sorts of forms, tables, reports, etc. I'm considering buying the Visual Studio Tool in order to package the Access file such that it can be distributed to people who do not have Access on their machines. I have a couple questions, though. First...

Hello. I have created an Access2000 database and "installed" on a couple dozen machines with various configurations of OS and Office versions without incident. Recently, I tried to install it on a Win98 machine running Office2000 (with Access) and received this error when trying to launch the...

I would very much like to convert an Access2000 Dbase (with forms and reports a quite a bit of VBA code) into something with a web-interface. My first thought is rewiting the forms using java or something similar. For example, I suspect .Net would handle it. All fo this assumes I have some...

I searched through the fora here to no avail. I have a database that I want to distribute. When distrbuting the database to a site, I want to be able to ensure that only a specific number of users access the database simultaneously. Or, that specific users, or specific computers access the...

Hello. I performed a quick search and didn't find anything to help, so if there is a previous posting that addresses this, I apologize for not finding it. My issue is I have built an Access database with numerous VBA code calls and objects. I also reference several libraries, as you might've...

You guys are so good that I'm starting to rely too much on you! Forgive me for that. Also forgive me for not searching for the answer to this question in previous postings - I'm in a bit of a rush, so I apologize if this is easily answered or has been answered before. Ok, I have a form with a...

I'm having an odd situation in which the same piece of code works on one machine, but not two others. I have a report that groups data by month and outputs that month to each group using the following function: =Format$([IssueDate],"mmmm yyyy") This works quite well on one machine, which is...

I have been able to define user-defined properties and set their value and later use them to populate fields on reports and so on. It works very nicely. However, I would like to be able to check for a specific user-defined property when a databse first starts up or create the property and set...

Hello. I have a form (frmPermits) that is based upon a query (qryPermits). The form has a combobox (cboRecNum) that is also based on a query (qryCboRecNum). The idea is that the user will select an item from cboRecNum, which is populated from a field in TableA. Then, the rest of the form...

Ok, I'm not a very experienced Access user/developer, and I have little to no VBA experience at all, so, please, bear with me... I have two tables: TableA and Table B. I have created a Form using fields from TableB, which are linked to TableA via the Relationship Tool. In the form, there is a...