Search results

Ok, Well I sorda fixed it. Since the autonumber cursor was set at 25000 I realized that I needed to trick it to thinking it was adding a new autonumber 20,000 times. So so I set up a macro that created a new entry in the Table 20,000 times and let it run. It successfully pushed the autonumber...

I created a database for my parents last summer and it has worked perfectly for a year now, then all of a sudden when they try to add an entry to the database its saying that it can't because it will create a new field. Turns out my parents have added 45000 entries and it has just randomly...

Sweet! Never noticed that! Thanks :cool:

Hey, I figured it out! My main form loads all the other forms inside of it, so I made it a popup, and when its a popup it steals focus until its closed, so you cant view the tables, etc. and when you close the main form, it just closes everything :D Thanks for the help, I think I will go...

I am not currently using any password or security.

Hi All, I know this has been posted many times before, but none of them addressed this problem. When you open the front end, you see the form that opens automatically and then you can also go look at the tables. If I password the backend and the forntend has connected with the backend (using...

How do I make a Return in a text box? I have this code being put into a textbox: The Chr(10) & Chr(13) give me Boxes instead of returns Me.boxBillTo = "Bill Address:" & Chr(10) & Chr(13) & _ Me.BillTo & Chr(10) & Chr(13) & _ Me.BillAddress & Chr(10) & Chr(13) &...

Nevermind I figured out a diff way On the Options Form I chose acPrint instead of Preview, now it just prints out :D

I'm Confused, whats the difference between Report_Open, and Report_Activated? Is there some kind of Report_IsDoneLoading? I have a form that gives the user the option to print a report. When you select the report you want to print, it runs a script to open the report. The report is set to...

Im trying to create a label to be printed on a dymo, and Im taking all the info I need and putting it into 1 text box, but the chr(13) isnt working, it just prints out a box. It works fine in a Popup MsgBox but why doesnt it work for a text box? This is my Code: Me.KeymapLocation = "KeyMap...

Ok I fixed it, I just scrapped the whole As control Idea and did As String, and put the Name of the listbox in the string. ;)

Anyone ever used the drag and drop control?

I am working on this drag and Drop Procedure http://support.microsoft.com/default.aspx?scid=kb;en-us;233274 It says to put this on the mouseOver procedure Private Sub List1_MouseMove (Button As Integer, Shift As Integer, _ X As Single, Y As Single) DropDetect Me, Me![List1], Button...

Oh, thats not cool... hmm...I could change it to a number field but then I have to go do that on all the Related tables.

Hey All, Ive got a form that im trying to make my own auto number for, b/c I alread have another field using Autonumber. Im using a text field b/c I want to have the Default value = "Autonumber" so that it appears to be an auto number. Can you use DMax on a text field? If not is there any...

I am trying to export the address book from Quickbooks in to may Access 2k Database I exported the Quickbooks file out to an Excel File, The only problem is the Ship to: Addresses are not parsed into Street, city, State, zip. It looks like this. Company name 1234 StreetAddress City, State Zip...

Is there a way that I can close my popup form when it loses focus. My clients will be double clicking on listbox to open the popup and I want it to close when they go to double click on another item in the listbox. Right now I have it set as a Modal Popup, which works fine but I'd rather it...

I FIXED IT! :D Seems that it was a bad record in the table I guess, When I got rid of it I got rid of my problem.

Thats the Thing. I only have Access and this 1 form running. It only seems to pupup the error when I change to the next record, then it seems like it starts running some continuous loop and it crashes out of Access. The only code I have on the form is to requery the list when you click on it...

All day today I have been getting this message that says im running out of memory. when I use this one particular form. It says "There isnt enough memory to update the display. Close unneeded programs and try again." This is an Access Popup, and not a window popup. This form only contains...