Search results for query: *

no, the connection is not timing out. it's not connecting in the first place

that has happened to me a few times, and each time, the forms (and other objects so afflicted) were FUBAR. Try making a copy of the form and see if you can open the copy. if yes, work with the copy. try creating a new database, and import the form into new database. if the form works in the...

I've done many searches, could not find solution... I have an Access front-end, linked to an Oracle back-end. when the user opens the database, there is no problem until they click on the drop-down box which pulls data from one of the linked Oracle tables. They get an error that says...

this might be a stretch, but I ran into a similar problem. my problem turned out to be that the users did not have full read/write access to the drive where the front and back end were stored. once they got full read/write access, that problem went away. Oh, and the problem only surfaced with...

Environ("username") seems really easy. are there any limitations to that method? I have been using the following code (which, to be honest, I don't really understand) to retrieve the user name: Option Compare Database Option Explicit Global intFrom As Integer Private Declare Function...

I did a few searches and came up empty handed... sorry if this has been covered many times: I'm beginning work on a new Access db, and I need to build a switchboard (as usual). in the past, I just did custom forms for everything. But since MS provides the Switchboard feature, I'm wondering if...

PHV, that query works brilliantly. I think it will take me an hour to figure out how it works, but I really appreciate your help with it. lespaul, I also appreciate your help.

oh yes, you guys are quick. I'm trying to use the query you showed me and I think it will work. I'll keep you posted, and thanks a lot! this is really great

I'm unfamiliar with the dot operator. Can you briefly summarize what S.Customer does, or maybe point me to a SQL reference that could explain it?

I have two simple tables: tblSched -sched date -sched amt tblPayments(received) -pmt date -pmt amt let's say my data looks like this (this would be for one customer, by the way) tblSched tblPayments 1/1/05 100 1/1/05 150 2/1/05 100 2/1/05 150 3/1/05 100 4/1/05 100 one...

that second one does a bit more than I was looking for, but it gets the job done. Thanks a lot!

In Access 2000, there is no close property for a report. Unless I'm retarded or blind. and I freely admit, either is possible.

for Access 2000? There is no such property. Am I just being blind?

okay, I researched turning off the close button for reports, and here's what I have: Option Compare Database Option Explicit Private Declare Function GetSystemMenu Lib "user32" (ByVal hWnd As Long, _ ByVal bRevert As Long) As Long Private Declare Function EnableMenuItem Lib "user32"...

does it have to be done through VBA? I don't see the property listed in the properties dialog box

is it possible to disable the control box (or just the close option) on a report? I want to be able to better control the flow of my app. When a user closes a report, I want him to be able to change his mind and leave the report open, or close with out updating records, or close AND update...

I found this, and it worked, so never mind. Option Compare Database Option Explicit Sub OpenPasswordProtectedDB() 'Define as Static so the instance of Access 'doesn't close when the procedure ends. Static acc As Access.Application Dim db As DAO.Database Dim strDbName As String...

so I've been thinking about this some more. There's no question that the changes I made improved the performance. And if it's not because I'm using recordsets instead of queries, than what can it be? Maybe because I'm opening my main form in the startup, and then hiding it after that instead...

I want to put a password on my database, but when I try to open it from VBA, I don't know the proper syntax for the password argument: Dim wsp As Workspace Dim dbs As Database, dbsOther As Database Set dbs = CurrentDb Set wsp = DBEngine.Workspaces(0) Set dbsOther =...

thanks guys, I'll check out the links