Search results

Awesome thanks, I dont know why I didnt see that seeing as its the first in the list. :cool:

Well, the data on the page does not get updated but it does change from record to record. This listbox contain a list of items that pertain to that particular record, and I need it to refresh as the user navigates to the next record. so that the user is looking at data that pertains to current...

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

OK, Luckily I had a backup from friday :D . I love habbits. I pretty much narrowed the problem down to 1 form so I deleted it and then Imported the backup form, so far everything seems to work. Oh and I compacted and repaired the database. and the database went from 24 mb down to only 1.2 mb...

Ok....seems like everytime it tries to autosave the database it gives me that popup, is there a way to repair the database? Ive got over 2 months of time into this database, there is no way im going to start over.

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

Wow I never thought about that possibility! Thanks

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!

1.) You must first create a table to hold your data before it gets appended to the real table. just copy the real table and rename it something like tblAppNameofRealtable. 2.) Create an append query, Query Design View, add your tblappNameofRealtable table, then click Add then close. then Drag...

You can do, On Unload = Save On Exit On Dirty = Save On Change But really in order for this to work right, you would need to have an Append Query, and then on exit Append that data to the table. Or have a save button and tell that to run the append query if all the fields are filled out...

Thanks for the Help I am asking all this b/c Im a Web Designer, and I like things to look nice, So im exploring all of the different possiblities to make sure I can get a Database that looks nice, is easy to use and is not to terribly hard to create. If I stick with access how do I split up...

Ok, so If I went with an SQL backend, how difficult would it be. Ive been doing databases(Web:ASP & Mysql, and Access 2000) for a year or so, nothing deep until the past month. Would this be something only an Expert should try to do? 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...

Awesome that link will help out A ton! :D

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

Its in the Active X controls so I asume it can be used. But that doesnt always mean its going to work.

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