Search results

Hi there, I have searched on multiple forums and found it is not as easy as you expect it would be. I tried making this work with forms and subforms in the 'normal' way, but this does not allow me to make a 'sort of' freezepane effect as is possible in Excel. Attached is an example that i've...

I hope you will find this information usefull. I use Outlook to receive reports and then automatically open the right access-database (with shell and command parameters) to process them. In my search for a way to stop my Outlook-code with processing untill the access-database has closed, and...

Hello, In VBA I'm trying to export 2 reports of my dbase as snapshots to a folder where users have access to. The code I use: DoCmd.OutputTo acOutputReport, "whatever", acFormatSNP, "T:\whatever.snp" DoCmd.OutputTo acOutputReport, "whatever_1", acFormatSNP, "T:\whatever_1.snp" The...

Case solved: I've been overlooking .SourceTableName = "Sheet1$" or whatever you want it to be... The following is the case: At our office we have users which use English and Dutch systems and office software. They pull data out of another system and export it as an Excel-sheet which gets...

Hello readers, How it (my dbase) works: I have build a routine that automatically updates the starting database when another database with a name starting with: "UpdateV" + (text-field value) is found in the same folder. (Or you can browse to it through a interface...) It then checks a table...

Hi, I have a problem with regional settings and programming the ColumnWidths of a Combo Box. I already posted this thread at the Forms forum however no-one there seems to know the solution to this challenge: My challenge: The company I work for is located in Europe and normally set the regional...

Hi, I have a problem with regional settings and programming the ColumnWidths of a Combo Box. The company I work for is located in Europe and normally set the regional settings of Windows to the Metric system. However, users in the UK use Inches instead of Centimeters. In my database i program...

Hello all, Here is a nice one: I use a maketable query to create two tables. These two tables are then copied and get another name. Now I want to use VBA code to set relationship (one-to-many) between those two copied tables. Is this possible? Grtz and awaiting input, m0use P.s. Need to...

Hi there! Is there a easy way to get a form opened, based on a query result? I only want forms to open when the result of the query is true and data is returned. Otherwise there would be nothing to see, right...? :) (I do know I can use RecordCount in VB, but I wonder if there isn't an...