Search results

1) Make a macro 2) Add the line RunCode - Your_Func() to that macro. 3) Drag the macro from the list to your desktop. 4) You now have a shortcut to a macro that runs your function.

It means that your query is somehow returning TWO record with an identical primary key value. For instance, if your table has a field called "ID" and that is set as a primary key, it means all entries in that colunm must be unique. So, this means that somehow you're getting non-unique results...

Im gonna type this quick, since I leave work in 15. FE - Queries, Modules, Forms, Reports, Classes BE - Tables Link the FE to the BE with Linked Tables. Make a Linked table to a control table in the BE with a vesion. Make a local table in the FE that contains THAT version. Make thier main...

I don't think your RecordSet is Updatable. That might be why you cannot do it like that. Not really sure, it's not my expertise, but just something I noticed.

Here is some code i use to update connect strings for linked tables. Perhaps you need to .RefreshLink the QueryDefs too. Public Function SetLinks(ByVal oUser As String, ByVal oPass As String, ByVal oServer As String) Dim i As Integer i = 0 Dim dbs As DAO.Database Dim tdf...

Split the Database in 2. Backend - Contains all the data. Frontend - Contains the forms/queries. Link the two with linked tables. Put the Backend on the network. OR Take the data and put it on an SQL/mySQL/msSQL/Oracle/whatever server. Same idea. Since windows networking is the suck-sauce...

Actually, I take back one of my previous remarks, it would look great for some retro pages. (No that's not making fun, that's an honest opinion.)

I know, something quite worthy of showing to future employers, but it's not quite possible. It's very integrated, and since im not on site all year, it's self-managing, with administrative control. However, small problems do arise, which is why im back in the x-mas season for a couple days...

As you may have gathered, this job of mine is seasonal. That link is from over 7 months ago. I just got back, havent had a chance to remove it. As for your suggestion, the databases are highly dependant on the oracle backend, and rely on 1000's of records to show even the smallest results. It's...

I'm going to say this as nicely as possible. I'm sure a great ammount of work was put into making these, and although very extensive, your collection of buttons isn't very visually appealing in my honest opinion. I personally would stick with the defaults myself, mainly because I cannot think...

If I could, I would. The work I do here deals with sensitive company Information. Unfortunately what I do has to be reflected via reference, not by work provided. This work is highly customized. However, I document my code quite thoughly because the poor fool who gets to decipher it when Im...

My VBA is a tad rusty, but in languages like C/C++/Java, you cannot execute a Switch (Select Case) on a string. Try This: 'Preview button includes: CreateReports (0) 'Print button includes: CreateReports (1) 'Elsewhere in the form's module I have a module: Private Sub...

Have you tried re-setting the Pass Through Connect String before you set the SQL. qdf.Connect = "....."

Dim fileNm as String fileNm = Right(fileName, Len(fileName) - InStrRev(fileName, "\")) ' Input: c:\program files\someprogram\mypic.bmp ' Output: mypic.bmp I hope this helps.

Im currently in my 3rd year of Computer Science in University, I work for a large corporation (Lafarge Cement) developing custom Access Databases that interface with Oracle and often use web-based extensions or interfaces. I am most likely being paid hella less than i should considdering the...

Not to be unconstructive by trolling your post, but do remember, we are dealing with Microsoft here. Anything is possible :eek:

Correction: Making my query a 'Select Query' allows it to run at a realistic speed. This however does not solve my problem, anyone know why this might be happening?

I have a query, it joins a local table to a remote table (Oracle Database Table) which makes it slow(ish). When I am in design mode and i click the "View Datalist" button, which visually shows me the results, the query executes in about 12 seconds. When I use the "!" Button to physically...

Is there a way to generate 2-3 reports and append them together into one preview, or perhaps export them to one Word File? This would help for generating multiple graphs in reports for a large set of data.

Is there a way to generate more than one report and have it appear as one in preview?