Search results

Folks, I want to use schedule a stored procedure to send a table from SQL server to a specific MS Access database. So i can utilize the power of SQL Server to create the table and send over the results to MS Access.

Folks, below I have two columns, the [EquipmentID] is what I have in a Access table and the [ID Column] is what i need updated in code. Can someone help me with the how the code would work to update [ID Column] field? H = Header or first record unique Euipment ID D = Duplicate of Header ID...

Hello everyone, I have been a member for quite awhile here on this site and I always enjoy everyone’s input to various solutions. Therefore, I figure I would post an INSERT INTO process that deletes a APPEND query then recreates it with the filters selected by the user built into the...

Hello all, I am looking for a way to execute a Stored Procedure on SQL server 2000 from my ACCESS 2003 front end. (Using a button) Does anyone have an example Access DB or code available that could help me make this happen? I would really appreciate!!! Kind Regards Steve~

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

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

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

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

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

Hello, I have a select query that is based on a 4-digit report number. The four-digit report number has 4 reports linked to it that need the four-digit code to print the correct information. Currently when I print from my form button, and it is linked to a macro that has all four reports...