I use Oracle SQL developer or Aqua Studio (installed on my local machine) as database access tools. I use VPN connection to connect my local machine to a remote Oracle server. I run SQL queries against Oracle tables on that remote Oracle server. I also have MS Access database on my local machine. I also...

I acViewPrint a one-page report with lots of subreports and 5 graphs. I want to export to BOTH Word/RTF and PDF formats. After I export to one or the other format and return to the report display, I find the graphs have reverted to a prior rendering. To workaround, I need to rerun the report. Is this...

I have two fields startime and endtime. I need to caculate a total time from the starttime to the endtime. Example: starttime value 8:00 AM endtime value 8:15 AM and get the total time of .25 hours.

I hav created an temporary table, as base for an drop down box, but when certain records are selected i want to remove them from the drop down box. I tried to use the delete fro #temp table but that does n't work i used DELETE FROM dbo.producten_land# WHERE (Videorights IN (SELECT recht FROM [Video...

I hav created an temporary table, as base for an drop down box, but when certain records are selected i want to remove them from the drop down box. I tried to use the delete fro #temp table but that does n't work i used DELETE FROM dbo.producten_land# WHERE (Videorights IN (SELECT recht FROM [Video...

Hello, how can i have the subform not run its query until i tell it to do so? ie. forms![Main]![Main_subform].requery Reason why i ask this is beacuse the main form takes long to open because the subform is running its query even though there is no data.

I have a button that prompts the user that records from one table is going to be merge with a record form a different table. That part works great. The problem is the message box has an OK button and the close button. When I click the close button it stills merges the records. I would have though the...

So, here is the situation. I have a spread sheet with several columns such as: NumberSets NumberConductors NumberGrounds These coumns have data in them such as: (1) (2) (3) In excel I have these columns formatted as a Custom Type (@). This allows me to enter in the number 1 and then have excel automatically...

Here is a scenario: On daily basis I am getting two text files (from two different systems)... I want to compare them to ensure that data in both the files are same... Here are the steps that I want to take 1) save files in a folder... this can be done manually 2) run a macro /sql to import both the...

When the user clicks add new case I have the Form open with ACFormAdd. On the On Current event of the form I have the following code. It works fine when the user clicks OK but if they click cancel the Form opens anyway. Any ideas? Code Snippet: 1: 2: 3: 4: 5: 6: 7: If Me.NewRecord Then If MsgBox("Assign...