Search results

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

Thanks. Thanks, Spacepro. I'll check out the link. I'm a fairly experienced programmer (C, C++, Perl, etc.), but am rather novice at the VBA and Access macros and so on. Thanks, again. When I have questions, I'll certainly ask again. Tom

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

Since I didn't get a reply... I went ahead and coded something up myself. In a nutshell, I created a tabel of login date and time and logout date and time. Then, when someone logs in, I look for records of people logging in without being logged out. If there are too many, I give an error...

I'm affraid I missed the mark... Thank you for the information, but I actually WANT to control the number of concurrent users. Furthermore, I will not know anything about the LAN upon which the database is used. In fact, it may not be used on a LAN at at - it might be a single user/computer...

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

I needed it, too, but have a follow-on question... I've implemented the code and it seems to work, but I noticed that you cannot have the references already "checked" or an error will ensue. What if I distribute this database along with the reference libraries that i want to reference, but the...

I tried these and it didn't work! After reading the series of notes i thought the answer to my issue was provided. Alas, when coded, it did not work. Specifically, it did not appear to load the references at all - at least the ErrorHandler was invoked every time. I obviously changed the path to...

so it didn't work... I was directed to this thread as I asked a similar question. After reading the series of notes i thought the answer to my issue was provided. Alas, when coded, it did not work. Specifically, it did not appear to load the references at all - at least the ErrorHandler was...

Thanks, but... Thanks for the suggestion. The site has quite a lot to offer. Unfortunately, I do not see a "download" section, so could you be a little more specific as to where to find a potential answer to my question? Thanks, again, Tom

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

Nevermind I figured out a way to do it. For the benefit of those who want the answer, in a nutshell, I did the following: 1) created two new fields in the table: one for the year and one for a number. 2) in the OnCurrent event I selected only those rows that have the current year 3) I...

Good try, but... I tried the OnCurrent suggestion by Fizzio and I think it would work except the autonumber field is not generated until one of the other table fields is modified, as you said. Here is the assignment that I am using: Me.PNum = Format$(Now(), "yyyy") & "-" & Format$([RecNum]...

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

A couple follow-on questions... I, too, am very interested in being able to resent the autonumber seed to a specific value. I have coded the ChangeSeed funtion as described by DBL in the post dated 04-05-2003 07:21 PM, but it isn't working quite right and I have a couple questions: 1) I have...

Ok, I figured it out... Turns out there was a MISSING library referenced before the one that was needed for the format command. I removed the MISSING one and it worked just fine. Thanks, anyway, for the help. Tom

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