Search results

DJN, I appreciate the response. I have DB1 producing a report through a linked table in DB2. The steps I must take to update the report consists of downloading data into a text file that is linked in DB2, then I must hit a "Update" button that runs a few lines of code that update a table...

Hello All, How would I run a procedure in DB2 from DB1?

1. Make sure your History Table Scheme's are the same 2. Create a Append Query to linked from the Main tables and appending to the History tables. 3. If you are using VB can do write a code linked to the button on the form that would look something like this. {title your button "Command2" if you...

Pat, I have another question if you have the time. The above code is poping up this message: "Increase MaxLocks per file registry entry" I understand I can increase my registry to support, but the record count could be as high as 100,000 records and I am not sure I should increase my mem...

Hello Pat, I have read many of your past posts, you could say I am kind of a fan. Below a friend of mine wrote the following code, however, we are having trouble with the code evaluating the part numberS in the sequence they sit in the table. [PR] and then [PR_Date] must be insequence...

Hello all DB Gods and Goddess's, I have a simple question about getting a balance per record. In the attached DB under the [table1 Query] is my problem. Everytime I try to calculate the first [Job] reduces by one, and then it ends there. example: each [Job] has a [QTY_OPEN] that I need...

query Create a query with a count coulnm and click on the [sum] button on your tool bar. It will list the unique records while telling you how many you have for each unique record.

Output Excel with Date in file name Below I posted one of my favorite codes. It places a time stamp on the excel file name so that you cannot overwrite a previous file you may have sent - great for history and archiving. Also, aziz look at the setwarnings code before an after. this will...

Close Database on Timer Ukraine82, Thanks for the tip :cool:

Wow I wish I had the knowledge to help more people as I see most people on this sight do. I must say Jerry, that was very impressive answer ;)

See attached DB I had to remove Station 4 to allow the DB to be posted.

Hello all, If someone could take a look at my database and see how I can make my tag validation take place that would be SO APPRECIATED!!! I have read through close to 600 threads on validation and I could not find one that would help me, due to my lack of vb knowledge. Subject: Data entry...

Validation ISSUE I enter a 5 digit number "12345" [Code] into a form linked to a table.[T_Station_1] Then I need to validate the number does not exist in an another table [T_Station_V] which are my voided numbers. Now I have been trying this in a macro set at after Update. With a MSG pop-up...

Dellboy, This Vaioman! Here is the VB code that will automatically set-up an e-mail from outlook, along with placing the distribution list you create in outlook. Private Sub Command19_Click() On Error GoTo Err_Command19_Click ' Open Report "Hidden" DoCmd.OpenReport "enter report name...

WaaaaHooooo!!! it Works --- Another question Master!! How can I add date and time >> 07-20-04 1:10pm :confused:

I am looking into it now, and I am hoping it works. Thank-you so much for responding :) :cool:

Hello All, I set up my DB to post its reports to a web-page file that allows everyone internally to view my reports using a web-browser. The Problem: When I refresh the report, it is automatically pasted over the one in the file. Therefore with certain reports I do not want the report copy...

Ivanteo, Thank-you for posting your findings, it solved my problem also!!!! :D :D :D :D :D :cool:

Skip thank-you so much for responding - However> I tried your suggestion and I get an error message [Object Required] Here is the full code - with your changes. Private Sub Command600_Click() On Error GoTo Err_Command600_Click Dim DateTime As Date DateTime = Now()...

Hello All, I have question about placing the date and time into the title of the report. For example: I send a report to a folder from my DB and looks like this. money.snp I want it to look like this money 12-09-03 5:29pm.snp Is this possible???? I hope all you DB Pro's can help me :)...