Search results

Let me rethink what im doing and ill post an update. thanks Pat

Thanks Pat. Thanks for pointing out the Date field problem. I haven't got into field names yet Im just trying to get the basic table layout figured out. The problem im having is that multiple users will be using the database so i need a way to keep all of the Payees, PayeeDetails and...

Here is the module that Ghudson was talking about Option Explicit '//////////////////////////////////////////////////////////////////// 'Password masked inputbox 'Allows you to hide characters entered in a VBA Inputbox. ' 'Code written by Daniel Klann 'http://www.danielklann.com/ 'March 2003...

Right click on combo box in design view. Click properties. Click event tab. click on the ... in the On Not In List Event. MsgBox "Your selection is not in the list.", ,"Not In List"

Hi all, Im updating my current checkbook registry database. Just want to be sure that table look ok to everyone before starting the coding process. This will be a multi user - multi account program. I have attached the relations diagram. Please give me some suggestions as to what fields i...

I have an application that does something similiar. How i handle this is i delete the contents of the emppic folder then import all active employees. We are doing it a little different i guess. Are you using bound or unbound forms and recordsets?? Here is the code that will delete the...

Thanks a bunch Jon. That is exactly what i was looking for.

Calculate time between events -- CLOSED Hello all. I have attached very little sample Access 2000 database with one table and one query. I want the query to give me the time difference between each entry. Example EntryID EntryTime **** This is what i want added...

Just thought i would post the lessons that i have learned in my brief 2 years of access programming. I am by no means an Access guru. I have only been at it for about 2 years but my projects are getting better and better. Some day maybe. I have done about 4 projects for my work and on my...

ADO.NET is a completely different monster. Very fun and interesting to learn though and I am still learning myself. I highly recommend ADO.net Core Reference by David Sceppa. This is the best book that i have seen so far. I worked with access unbound for about a year thinking that it would...

Thanks Cable. I figured it was something simple. Hooks

Good question Wayne. I am planning on making a status bar for bound queries and reports. I'll post it in the samples section when and if i get it done. It has been awhile since i worked with this status bar but i beleive all you have to pass to it is the maximum count of records (In my case)...

Posted sample in the Sample Database forum. Please give feedback as i want to make this a better progress bar that can be easily implemented in any access database. Hooks

Ok Ill Post one later today or tomorrow.

Wayne I have a parameter where you can set the Granularity. I just had it set to 1 for testing purposes. If i change it to say 10 or 20 the program takes just as long as it does if it is set at 1. My progress bar form is only repainting if the percent processed has changed. For example...

OK, Here is my little progress bar. Please help me make this more efficient. As it is right now i am opening up a recordset that has about 950,000 records in about 12 seconds using my progress bar. It takes about 7 seconds to open the query without the progress bar. I know this isn't that...

I am almost finished with an unbound form status bar that will be able to be called from any other form with properties for status bar color, at what percentage to update status bar and minimum number of records to display status bar. I have tested it with a 950,000 count record set and it...

If msgbox("You did not enter in a value, would you like us to enter Working for you", vbyesno, "Missing Current Status") = vbyes Then DoCmd.GoToControl "txtTopic" cbo_Status = "Working" Else DoCmd.GoToControl "cbo_status" End If Something like that.

Doc_Man, I have the excact same setup as you. This is really driving me crazy I identify the picture with a field in a table.

Cera did you figure it out? If not i will try to help you as much as i can. Im no expert. hooks