Search results

Gentlemen, I have an issue trying to connect to a remote backend-db that is residing on another PC in the LAN (192.168.x.x). What I do in order to reach the db is the following (wrk_spc is a workspace, and cust_db is a database): Set wrk_spc = CreateWorkspace("my_space", "admin", "") Set...

Found a way to fix it (another thanks to the forum): used worksheets.add to create the desired number of worksheets in the new workbook. Looks like it's not possible to use SheetsInNewWorkbook for solving this task - or am I mistaken?

Gentlemen, I'm playing with exporting Access query data to Excel; on the whole it works fine (thanks to the info I found at this forum), but I can't fix one last error. When a user pushes the "Export" button on the form, the first thing the program does is to check if the target Excel-file...

Cool, thank you very much :)

Gentlemen, I'm now trying to cope with a somewhat similar task - need to format an Excel file I export data to. I have an issue: when trying to declare things like Set xlapp = New Excel.Application I get an error message 'User-denied type not defined' - in a word, Access seems to be unfamiliar...

Thanks again, this is the right way :)

Looks like it helped... thanks! :)

Gentlemen, I have an issue with the scope of a recordset. I declare it as Public in the General Declarations section of a form module, and it works fine throughout that module; then I need to use it in another form module - and here's where the problems begin: it looks like Acsess just doesn't...

Exactly - and this seems to be somehow connected with the "subtable" issue I had. I got the problem fixed only when I deployed independent controls (a set of text controls plus a subform with a table) linked to one and the same record source.

Have further investigated the problem. Part of what I said earlier is not true: when I create a sub form having as the record source a table or a query somehow linked to the main table, I get both the main table and its representation on the form "upgraded" - each line in the main table gets its...

Hi everyone, I have a "split form" in Access 2007 (where data is shown both in a table and in a set of text fields), and I'm trying to build in a subordinate form showing data from another table (linked to the first one as "one-to-many" with "one" on the side of the 1st table). It all works...