Search results

Did you refresh your link with SQL?

Now what did I do wrong. I created a new forum. Tried to use the Wizard for creating a sub form then I got a message "For Loop not initialized". I’m running 2007 with a split SQL running in the BE. Any ideas or thoughts would help. Thanks

DCrake, I might try it sending it to you. I will check and see if I can at least send you the shell. Thanks for the offer

Coach, that will be my first order of business. Get them all on the same page using Access 2010.

Coach, thanks for all the hot tips. Maybe I should have said Task Pane. Now since you mention Access 2003. I kind of remember that you could custom build Task Pane. Just looking at this dB again. Where it’s says Reports, I have a drop down list of several different types of Reports. You...

If access is loaded on a server, Do you have to have access on your computer to run the access on your computer? I am hope I ask that correctly

Coach, thanks for the quick reply. But if its split I should at least see a normal Task Bar? This one is completly custom. I show the following: File Edit Players Reports Window Help. In all 6 selections there is various drop downs menu selections? Coach, you have been around for awhile. I...

Hey all, I need some thoughts here. I pick up a small side job, so I thought. When I first open it was access. When I tried to see all the objects, it just had the queries and tables. So when I install the complete application the forms came into play. So then my next thought the forms are...

Running MS 20007 Split DB, SQL in BE Secured (user must sign in DB) The following is what I am trying to accomplish: Alarm type function for a form to pop up when the user is log into the database, when a particular date is due for a report. I would like for the user be able to use the check...

Chazm, I am doing it a real ugly way. But it will work. Export to Excel and then Import from new DB. Pain staking job. But I think it will work. Thanks for all the input

Bob/Chazm Chazm, thanks for chimming in. Sorry I ddid not back to you guys fast enough. Chazm I don't have a copy of SQL at the house, so I guess that idea is out, but thanks for the input. Bob, I created a new DB. I could not import due to the other DB is secure. So I thought maybe I...

I have Access running as the front end and SQL as the back end. What I would like to do is take a copy of DB and do some work off site on the DB. Of course the tables are link to SQL, which makes it impossible to work on. Is there any other way that I can make this work. I don't want to...

JR, that work like a charm. Once again many thanks

JNAR, I attach the wrong db, what a fricken idiot I am. So sorry

JANR, First of all thank you ever so much helping me.:D I tried to work with it for a couple hours, just could not make it work.:confused: See the attach

JANR, thanks for the quick reply. I tried the txtUser, and that did not work as well. Any other ideas?

JANR, not experienced in VBA code, I have copied your code and pasted it in the BeforeUpdate Event. I am getting a Compile error: Method or data member not found (shown in red) Private Sub Invoice_Number_BeforeUpdate(Cancel As Integer) Dim sWhere As String sWhere = "[Invoice_Number]=" &...

I think I found my answer http://www.access-programmers.co.uk/forums/showthread.php?t=200376&highlight=duplicate Being new at VBA I really don't know how I would insert the correct fields. The table I would use is called tblproclog, the form is called frmPE, the subform is called frmlPESubform...

Need a thought process here. I have a form with all the information for a contractor I have subform that is link to the contractor showing all payments. On my subform I have field for Invoice number. What I am trying to accomplish is not duplicating any Invoice numbers. I was thinking about a...

DB is split with SQL Running MS Access 2007 I goggle the error msg and found it has to converting the db. This db has been converted for some time now. I just received this message when I tried to modify a form. Being the admin I full rights. I can't rename, modify, or delete the form. I...