Search results

Hi, I thought an accde file, wouldn't give the user access to the tables and queries, but I don't see any difference to the developing file. I remember in the older versions you could create an exe for the user. How close can I get to that? I would like it to start with my form frmMain, and...

It works for me! I read it somewhere and tried it. I think the main purpose is give you a chance to say exactly where, say, "Main!B2:c7", but just the name seems to change the sheet name from the table table to that.

Ah, I've found it... It's "Range" oddly enough ;) Thanks

Hi, I was wondering if I could rename an excel export. I'm actually surprised there isn't a "sheetname". I guess I could rename my query table but I don't want to, die to organisational reasons. Here is my statement: StrTable="3_boxphase" Docmd.TransferSpreadsheet Transfertype:=acexport...

Yeah, sorry for replying in words. I liked what you wrote, and made the appropriate changes to delete from, rather than drop the table:) And yeah, I used insert into select ;) thanks for that. So I guess this thread can be closed.. Or do I close it?

Ok, to give you whole the picture, I'm using pass through queries to access a database, because the query is complicated, consisting of functions like "lag", which are difficult to implement. It is also a cte query, which is more legible in is form. Now this query is dynamically created with two...

Hi guys, I was wondering, I have an SQL statement which was dynamically created and which I have stored as such: Set Qds = DBs.querydefs("PT_query") Qds.SQL= strSQLQuery Qds.returnsrecords = True Qds.Close That works fine.. Then I delete the contents of a table: currentDB.Execute "DELETE...

First of all, thanks.. I've got a problem with this, which might explain the general difficulties I'm having. I can't declare like you have. I get a compilation era. To elaborate, I can't say dim objXL as excel application. It gives me a compiling error. Why? In my reference, I have Microsoft...

Hi guys, I'm trying to simply export data in a recordset to an excel file, which I show in the code. Unfortunately, only a manual entry of the expiry file and path is possible. Here is my code: Set rs= currentDB. Openrecordset("dynamic_query", opensnapshot) Set objxl =...

Fantastic!! Thanks for that!

Hi guys, I've got a complicated CTE query (strQuery) which works as a passthrough query, so I needed to dynamically set some dates in it, and execute it via VBA. I get an error 3129, meaning that it expects, instead of "with", delete, insert, select, or such likes.. Here is the relevant code...

Thanks dude.. That did it!

Hi guys, I'm trying to access a file which seemingly exists, but gives me an error 5. Here is my code: `Strfilepath="...\query.txt" Set DBs = currentdb() Set fso = CreateObject("Scripting.FilesystemObject") If fso.FileExists(strfilepath) then Set file =...

I was wondering, I have quite a complicated query using lag function and stuff. So I need a pass through query to successfully execute it. However, there are a couple of date parameters ( date_from, date_until) which I would like to add to the pass through query. Is that possible? Ideally, I...

That was it! Thanks..

No .. No docmd.maximized anywhere in the code.

Hi guys, I am using access 2021, and I'm having problems finding why my forms always open maximised. I've made the forms quite small but when I double click it to start it, it opens screen size. I'm probably blind as to where to correct this.. Thanks in advance

Admittedly, I might be misusing the functionality of a tab control somewhat, but I feel it shouldn't be such a problem to fill a Tabcontrol dynamically according to the contents of a table or tables. By the way the table I described was just an example so let's not dwell on the content. I am now...

The number of pupils are irrelevant, as it goes through a recordset with the pupils and creates "While (rs.Eof = false) "

Ok, I'll explain the actual problem and hope for an adequate concept to solve the problem. I am a headmaster and a teacher of a class of 12 people. The names, age and sex are recorded in a table "pupils". So as I log in to the application, I would like the tabs of a Tabcontrol on my form to be...