Search results

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

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

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

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

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

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

On my form I have a list that needs to be updated whenever the user changes to a new record. right now im using the OnMouseDown command to Me.Control.Requery, that works fine but I would like the listbox to requery as the user is navigating through the forms. Thanks

My Database has gone Psyco! I was working on a form and then all of a sudden I get this popup message "You Canceled Previous Operation" It pops up anytime I click on anything now, And Noo it doesnt just pop up once it pops up about 5 times evertime I click anything. So I closed out, and...

Does any one know how to change the source object of a subform, when you are Inside the subform? I have a Form, with a dynamic subform, in that subform I have a form called "Find Client" Loaded. When you find a client in the list I want the user to be able to double click on the client and...

Does anyone know how to get 2 forms to maximize side by side like this. This is a form created by PaddyIrishMan: I love the format, and it would be perfect for my Database UI. So if PaddyIrishMan or anyone knows how to do this that would really help out alot. Thanks!

Ugly Access, Alternatives? I have found that Creating forms in access, while they work, they look ugly. I'd like to use Visual studios to make the Front End Program. In the end the backend will sit on a central server and I will have approximately 6+ front end apps connecting to the database...

Hey Yall, I'm new to programming in access and I would like to make my program look as professional as possible. My main question is etiquette, naming tables, querys, forms, macros, reports, and modules. I Have seen a few people use tblTablename before, is this the standard? If so please...

Hi I am trying to create a date modified field for one of my forms, and I dont see anywhere in the form properties for "onSave" Whats the next best thing? I tried this with no luck Public Sub Form_AfterUpdate() Dim updatecheck updatecheck = 1 End Sub Public Sub Form_Close() If...

I would like to create my own title bar, kinda like the Quickbooks title bar. But I can't figure out how to import my own pictures so I can make it look nice. Any Ideas?

Im trying to query my database for the Biggest number in a column then put that number into a Variable. I have no idea how to do this, I tried this: PrevJobNum = DoCmd.RunSQL("SELECT Max([Jobs].[JobID]) AS MaxOfJobID, [Jobs].[BusinessID] FROM Jobs GROUP BY [Jobs].[BusinessID] HAVING...

Id like to change the properties of my continous form from Allowadditions "No" to Allowaddittions "Yes" at the click of a button Because when the form loads it has that blank field and the bottom, and I dont want to see that unless I want to add a record. What kind of VB will I need to write...