That is very close and it gives me some ideas. It would work for new lamps added or installed after the circuit was completed. However, there is another...
Jim, I tried to put together a small example. Table : tblJim fields : - autonumber - number (single) - ADDED field : sortnumber The function below fills put...
Here is how I did something simular in one of my reports. Basically I did not want to count a record if the Primary Street and the memo filed were empty. It...
That's how an export works. If you want to append, you will have to write to the file. Here's an example Public Sub ExportRecs() Dim intFileNum As Integer Dim...
Thanks Bill for your comment. Do I have to have all the connection code since this is a database that exists locally on my computer and I just want to append...
In the properties of the text box the If statment is is, click on the data tab. At the bottom of the options for that tab, Running Sum is normally set to...
Essentially, I use Count(ENROLLMENT_LIST_ID) to determine how many students are in a course. Really what I need to do is IIf(Count(ENROLLMENT_LIST_ID) = 1, 1,...
I am trying to grab a record set, but i am not getting the first record. I am a total VBA noob so I know this is probably a very easy problem so any help will...
How about this? In the report place a blank text box. look at the properties for it and put in this statement. IIf([PersonID]="",0,1) at the bottom of the...
I don't have know how to do that. Can you walk me through it? ... === message truncated === __________________________________________________ Do You Yahoo!? ...
To this I can attest!! There is a batch file that I wrote in the files on this list that deploys new versions of a front end to each user's home drive. I place...
Ok, Jim Open your code window ( Alt-F11) Choose on the menu : Tools/References Scroll down (almost to the middle) until you see Microsoft DAO 3.6 Object...
I am wondering which method is better to use for a query. 1) For each query set up the necessary tables relationships in design view, and extract the columns...
Good morning, I have been stuck with the Data Access Page. What I would like to do is to create one button with the Javascripts embeded. When the record has...
Hi all hope your well I'm after some ideas on how something could work in access and if it's indeed possible. The task I'm trying to create and job delivery...
Yes, the code goes in the database. Create a form. Put a command button on it using the command button wizard. The button's click event should call the ...
Is there a way to get that the SortNumber back in the number field so that field gets rid of strange numbers like 3.512 3.61, etc? ... === message truncated...
Thanks. I think I'll look into breaking my databases up into front end and back end ones and using this batchfile. I ended up making most of the front end...
Rick, In absence of Beth, who might not be available over the week-end, I would like to put forth the following. Your existing code for populating the list box...
To All Could someone help with the following. I have a form that has several options for a report that is the same format for all options. But the options are...
Is there any program out there that can create forms and VB code buttons for example beeps 5 time and search button for a field and the list goes on. Thank You...
I am going to develop a Banking Solution for very small branches of a Bank. The branches are standalone and no remote transactions will be made i.e. only the...
Hi All, I am going to develop a Banking Solution for very small branches of a Bank. The branches are standalone and no remote transactions will be made i.e....
Marcus, Guidelines need to be considered in proper perspective. Quite often, repeated admonitions against use of certain styles or features, create the...
Marcus- Because of the OUTER JOIN, you're getting at least one row even when nobody is enrolled - and COUNT counts rows. I suspect you'll need a subquery to...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
