Search results

I would use: CurrentDb.Execute "INSERT INTO tbltmpRecipients " & _ "(TotalRecipients) SELECT " & varDM & " FROM xxxx", dbFailOnError you should specify table (xxxx) where from you want your values to be selected. Rgds, giedrius

Hello, I am using simple INSERT INTO query a lot of times in different forms. What would be more effective - to put INSERT INTO once in a procedure and call it every time it is needed or simply use INSERT INTO a number of times as needed? Thanks, giedrius

Len, Your syntax works just fine! Thanks. giedrius

Not sure what you mean by "FROM in an INSERT query". Does INSERT have a FROM clause? I use syntax like this: INSERT INTO clients (client_id, client_name) SELECT supplier_id, supplier_name FROM suppliers UNION ALL SELECT supplier_id, supplier_name FROM suppliers2; and it doesn't seem to work...

Hi, Does anybody know if it is possible at all to have a UNION SELECT statement within an INSERT INTO statement? thanks, giedrius

Hi Wayne, Your example refers to continous form, doesn't it? Or does it apply to datasheet form as well? giedrius

Hello, I was wondering is it possible to change individual cell format (for example background) in a row in datasheet view in A2K. I need to do it from code. Conditional formatting doesn't help as my condition is quite complicated. Thanks, giedrius

It looks like this is a flaw in A2K. I've read about it here http://members.iinet.net.au/~allenbrowne/bug-02.html .

My experience is that FE might increase very significantly in size during the design process. In fact I have a very strong feeling that Access does keep copies of deleted controls or even controls that have been moved from one place to another. Therefore it is essential to compact your FE before...

I have three controls (say A, B and C) on my form, which receive focus one after another sequentially. I need to track Enter or Tab key presses for the field B. However when I put code into On_Keypress event for control B, it fires when the user hits Enter in field A. In order to catch Enter key...

This is OK when you have a simple sort. In my case it is a sort on more than one column and I want to give user a simple way of just clicking on the title of the main sort column. giedrius

Tim Thanks for your good explanation. It is a good starting point for deeper investigation into the subject. I really appreciate it. Giedrius

Not sure I understand what does it mean "to subclass". I am sorry, I am not very experienced in Access. giedrius

Hello, Is it really possible (and how) to get hold if a user clicked on a column title (selected the whole column) in Datasheet view on a form? I want to be able to reverse sort order of the marked column.

Well, I've been developing my application's front-end (FE) every day for quite a while. After I finish my day's work I would always first compact the database, then exit. Little by little my FE grew to 10 MB. One day my FE grew by some 3 MB and I got suspicious. During that day I didn't add many...

Hi all, I was wondering if you could point me to a good add-in which would enable to copy all the objects from one data base into another. Honestly, I got sick with all those bloating issues and after having read most of what is available on the net and some experimenting by myself I came to a...

I formatted it with format=fixed, decimal places = 0. There is nothing else I can format, isn't it? giedrius

Strange format in dropdown list of a combo box Hello, I have a combo box where I can choose a number from a drop-down list. Rather than displaying '1' or '2', it displays '1.00' or '2.00'. Format = Fixed, decimal places = 0. After I choose the number, the value in the combo is properly...

Thanks for your advice. giedrius