Recent content by racemadnss

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...