Search results

I appreciate the understanding from both of you and gemma I will look at adding the hourglass to the code - good point thanks.

The ShellandWait is another overly complicated program that someone created that was much more fluff than a lot of simple programs need. gemma you mention that the time may not be long enough, and that is something that is up to the person using the code to determine. Whether you use the couple...

An API is really complicated and for a lot of people they are just looking for a quick fix. It is not for me to question why you want Access VBA to wait; I am just trying to provide a simple solution that will work.

Personally I think that is too much work.

I have seen this issue posted a huge amount of times so I am going to post how to resolve this issue. Access does not have any type of wait, pause or sleep functions. So the question is always, "How do I make Access VBA wait for some length of time before going on?" The typicall answer is...

Well that is the rumor I read about. There site says that Access is supported ODBC level 4.0 and thats all I have.

F11 is a shortcut so you need to find out what has disabled it. Could be the settings or a module.

I looked at connection strings but it only has basic ODBC info and the way it looks in code. The problem is Cognos reports live on the internet as far as I know and I am not sure how to get to them. I will look up Carl's site.

I posted this in the general forum and didn't get any response so I came here since it deals with linking tables. I am trying to link to a Cognos ReportNet report. I have read that it can be done but no one seems to have any detail about it. Any help would be much appreciated.

So does anyone know anyone that might have info about ODBC connections to Cognos?

But if you create a pass through query doesn't that also keep the UID and PSW?

If no two people are working on the same document I don't see the issue unless you are saving something in the table and all your users are using the same table.

Public x as string This is the closest I know of to a global variable.

A music database like you are talking about would require the user to have the songs on their computer in the same location as where you would program it to be. So unless you are providing the database and the mp3 files they won't have them. The only other thing I could think of would be to...

You can't have two users saving two changes to the same document at the same time. How would you handle if UserA makes a change and UserB makes a change to the same record, who's save get's priority? I can't tell from the example what you are trying to do but it sounds like you have UserA make...

What I do I zip the front-end that way if each user unzips the file they get a copy. This also works great for version control because if you ever make changes to the front-end how will you get it to your users. The zipped front-end handles that.

Like Darth Vodka was saying that error means you are trying to put information into a field that won't except it. I.E. text in to a number field.

I started with VB (Visual Basic) because you can do more advance things with Access if you know that. It not as bad as some people make it out to be. Yes there is a difference between VB and VBA but with a general idea of programming it will come easy enough.

A 100mil is a lot, largest I have worked with was 16mil with no problem.

You could also use an AutoExec macro to open the first form.