Search results

Just a little explanation of Dir() Just to specify, the Dir() command return the first file in the dir, not the entire list of files. You can call it multiple time to get different files until it returns an empty String.

Heuu.. something honest? ;)

In an utopic world... Thanks for that extensive reply, Doc! It's just too bad that the actual server belong to my client. If it was mine, I'll be more than willing to make it like you proposed! In fact, I am about to make one of my own and your tips will be very useful! I like the idea of...

PABKAC, lol This is what I call a Layer 8 issue.

What about the "LOOSE"? I don't base forms on whole tables and don't use SQL Server. Just good 'ole Access back-end. Thanks for the tricks anyway. About putting tables that makes my combo/listboxes in the front-end, I never tough of that, and I think it's brilliant, since my front-end is gonna...

Thanks! Thanks for the links, now I have something to back-up the hours I'll be spending on this, this will helps my client to understand the need of usign a front-end on each machine. I don't know if I'll use "Auto FE Updater" or if I'll do my own updater. For security reasons, my client...

Thanks for the info, GHudson! I never get any runtime error when it crashes, but it might only be because I use some error handling in the form's code. I'll check for that. The difference between the two buildings? About 20 miles... :D Seriously, the Back-end is located on the server in...

Hi folks! I've been experiencing a very frustrating problem recently. One of my databases crahes randomly, and I'd like to know if some of you have tips to helps me. The database is splited in front-end and back-end, both on the server. I know keeping the front-end on the client PC will...

Ok, another one: http://www.ebaumsworld.com/flash/honda-ad.html It's an Honda ad, but I'm not being paid to put this here... ;)

One street entertainer I would give a couple bucks! http://andy.saturn9.ws/Photo%20Albums/sidewalk/

Good news!!! I made an Audit in an Access database that does all I stated above and much more! It's in beta test, so It might need some work, but I'ts mostly done. I still need to write a documentation. And it appears that I have the intellectual property for this code!!! Its good to be our own...

Just to be sure, you're talking of the Access User, not the Windows User, right? In that case, it will be CurrentUser. In the other case... well I don't have a clue, but its probably possible using an API.

Solution!!! Update! It appears that this is known problem that is carried around since Access '97. Here is Microsoft's sorry excuse, along with a solution : Microsoft support In short, put the function you call from the OnAction property in a class module, not in a form's module. Stupid bugs...

Try : .OnAction = "=suppPersonne (ARG1,ARG2)" BTW, what are ARG1 and ARG2, variables or constants values? If you funtion suppPersonne is in a form, you might need to call it that way: .OnAction = "=Forms!FormName.suppPersonne (ARG1,ARG2)" Lâche pas!!!

The cause, but not the solution... It appears that, when using the OnAction property of a popup menu, the function breaks and is called multiple times (in my case, 3) if the function calls a control on a form that cause an event (like Form_Current, or the BeforeUpdate or AfterUpdate of a...

Solution!!! Application.VBE.ActiveVBProject.Name works perfectly!!! Thanks for putting me on this track!!!

Exactly, but what's the code to get it? :confused:

I create a new record and delete it.

Hi! I try to obtain the application name using VBA code. I know application.currentproject.name , but it gives me the 'file' name. What I want is the title I've put in Tools> ApplicationName properties menu> General> Project name in the VBA window. Anyone knows?

In fact its: " VALUES (" & rs!kod_horaa & ", " & CSQL(rs![yadid.yadid_kod]) & " ," etc. The CSQL function adds apostrophes at the beginning and at the end of the string. I found it more easy this way.