Recent content by bulbisi

interesting ... Generally once my program is working smoothly, i do not touch it anymore. But in some cases when the files is taking too much space even compacted, I take a dive in it to see what I can improve. In this special case, it takes about 300mb per compacted file, and we keep 1 copy...

this is right that would save me some size but actually, the EndOfMonthDate is not always the same month, so i do need to pick most of the info from an ODBC. Then only I fill the empty fields with the last month. Everything is done in a previous table. Then I need the EndOfMonthDate to calculate...

You are right so to remind it to me. I created another DB using a different place to store temporary tables. It worked well but due to the fact that the server here is pretty slow, I didn't want to do it again (connection to another DB is sometimes too slow). Moreover, I didn't know this project...

well, i mis-explained, sorry i use T_CE_TOBE to create a list for other filters (cannot update it straight to T_CE_TOBE so i have to play through another table or query) and the result produced in the query is added in the corresponding record back to T_CE_TOBE. So i didn't mean Append, but...

Hello all, it looks like i have an issue. I wanted to avoid a kind of temporary table as the DB I'm creating is quite heavy and complex already. Before: 1 Append Query to Table 1 Update Query to fill a new table from the previously created table It worked like a charm but was way to heavy and...

It is a loss for the forum and the community in general. My condolences to David's family

Ooops, my emergency was longer than I thought: I needed 2 weeks to solve a bunch of issues all related. And then I forgot to get back to you. Did you manage... whatever? :)

I now have an emergency at work, So I'm going to guide you only. no time now for coding. first note: you can't use "name" as it is a reserved word for Access. You may use Firstname instead. your form: firstname=bound to your table then add: Birthdate = unbound Address = unbound Make sure in...

SOLVED I was busy trying to update straight in the table whil a simple update in the form field was doing the job perfectly. I should thanks myself here but unfortunately, I can't :)

I get your point, I did a similar code 2 months ago Just imagine you have a tabular form (listing all your records). Somewhere you add an unbound field. Then you have 1 part of the code to 'catch' the key number or unique value of your record. Because of that unique value, you can tell your...

Sean, in your form, create a textbox, and also a button (onclick) for example name the textbox "txtNewValue" and the button "clkUpdate" in their properties On the properties window again, select the clkUpdate button, Event, On Click, [Event Procedure], Module (I have the Access 2010 so it might...

Well, I had some difficulties to choose the right forum zone. Because it is most probably a VBA solution attached to that form problem. Here we go: I have a form (jpg attached) with checkboxes, When clicking these, it runs automatically a VBA function in order to update the value of the...

Good one, thanks Simon http://www.nzherald.co.nz/ for news, updates, photos and videos, Christchurch is still keeping 2/3 of the head page

Just working well, simple, so exactly what I wanted. 2 variables were running, but the second one needed the result of the first one. The time between was too short (or my computer too fast) and the second was therefore empty of values; so I needed to create a pause (1 second enough!).

;) Yesterday I got news from my Christchurch' friends. They are good ... compared to many others, their house is partly broken but all members of their family and their friends are fine. They do their best to help out around and confirmed electricity and water are rare, like mobile...