Search results

Use the before update event for the form.

3) You want to use a Combo box. A combo box can have a list of values that the user must select. You can also set a combo box to "limit to list". This forces the user to select something from the list before leaving. The list can be populated from another table, query or values. I usually...

You are violating an important rule of normalization. If you can always create sub from main, you have no need for the sub field, it can always be created using left(main,4). There is no need for this field. Eliminate the sub field or make sub and main separate tables with a relationship.

This is how we do it for Applications we develop and distribute to customers. We create a front end and backend. We also have a routine where the customer can select the path of the backend tables. Once selected, we have a routine that links all the required tables. There is an activex...

Jon, I would be interested as well. But like stated before, there needs to be some way that the customer doesn't get multiple contacts from the people in this forum.

Make sure the database is not being opened exclusive. Also if the database automatically launches a form, this form is probably bringing everybody into the same record. If this is the case, try using a menu or switchboard that opens first. This way everybody isn't going to the same form, same...

The database is probably not gone. The utility renames the dabase to something else (i.e. db1.mdb, db2.mdb). Once the repair utility completes successfully, the orginial dabase is deleted and the new compacted/repaired database is renamed back to the original name. Look for a dbX.mdb (X is...

One of the programmers I work with swears by Speed Ferret.

If this works, its much simpler than my solution. One thing we need to check to ensure any 0's after valid numbers remain (i.e. 001-010-02 should return 001-10-2

Try this. You will have to call this from your query. I used the immediate window to test the function and it seems to work. Function result(Field4 As String) As String Dim cnt As Integer Dim blnAfterDash As Boolean Dim blnZeroOK As Boolean blnZeroOK = True...

Ditto. Besides your own skills, Doug and I are here. I will continue to monitor. And although my version is easier to understand, not sure if it holds when you start to have 1) multiple digits behind the period and 2) multible letters.

Not sure what you are asking here? You have the basics. You just have to get started and design the tables. What more help do you need? If you're asking someone to actually design the tables, not sure if anyone will do this without some compensation. I will offer any suggestions though...

OK here is a sample. I used the switchboard wizard which I don't use often, but you'll get the idea. I documented the branch form. Let me know if you have other questions.

Yes, all of this can be done with Access with some VP. The is a command called "Like" that does what you were asking with the fir. You will use the wild card character "*" where address like FiR*. The only thing is you will have some learning to do. My suggestion is spend your time in...

Some things to consider to make it easier to distribute the database. Create the one record in the branch table and give it a branch name of XX. When you open the database, check to see if Branch = "XX". If it does, open the branch form and do not let the user close the form unless Branch <>...

Read carefully what dcx693 is saying and if what you really need is to take multiple selections of a listbox than you will have to make the listbox unbound and if its a case where you want to combine all the selections the user chose in one field, you will have to write code to enumerate through...

I'll take a shot at this, It sounds like Table 2 is really a transaction log of changes to Table 1. This could be difficult because if the primary key is allowed to change, you may not be able to link the two tables. You may want to try recording what changed for the record and not keeping...

OK, I'm glad it worked, but be forwarned. The whole basis for MS Access is the relationships between tables. Without that, you could run into problems later with those tables that should be related to tblheader. I can tell you how to run an unmatched query without the wizard. I will monitor...

Dude, that is the key to your problem. You have what we call "orphan records" they are on the "Many side" of the join, but not on the one side (tblHeader). The records on the many side need to be deleted OR you need to add a corresponding record in tblheader. To find the orphan records...

Try This DoCmd.OpenQuery "queryname" This command will be put on the On Click event of the Button on the form