Search results

THanks to both of you. I'm just trying to implement it now.

Hi Pat, A couple of questions of you dont't mind concerning your response to Linderick. In his example (and my case) the counter (ie autonumber) is needed to run incrementally for each product group, which are all stored in one table. For example SWAP001 SWAP002 LOAN001 LOAN002 Am i correct...

It certainly is possible to send an email to notify other users. Have a look at postings by BukHix who seems to be a bit of a guru on this issue. Rgds

How does the user "save" the record? Do you have a save button? If so, you want to set up a msgbox with the message required. In code try msgbox "You have successfully created a record", vbinformation, "Well done!" If you use macros, i think messagebox is a docmd action

Andy, In the properties - format - column count of the combo box check how many columns there are. You want the number to be 3. For column widths, try 2.54;2.54;2.54 HTH

Hi, If all the user does is enter todays date into the textbox for the purpose of the query, can you not omit this and then change your query to between date() and #30/12/09# This should get around the problem and cut down on what the user has to do manually.

DCX, Cheers, have noe got it working. On the sub form I kept the text field but added the ID field in a non visible text box. It is this that I move into the combo box and all is good. Cheers, M

I've got a sub form that gets re-used on a number of forms. It is controlled by the same control (combobox) on each of the main forms. The sub form gets its data from a recordsource that is an sql statement. I can get it to work by naming the main form in the criteria (ie...

Unfortunatly, neither do I! These are the two methods that I normally use. Post a sample and I'll have a look for you.

There are a few samples in this showthread.php?s=&threadid=34436&highlight=compact for using code to comapct other dbs (typically BE's in the samples)

Probably your biggest performance issue at the moment will be related to your table structure. Have a good search for normalisation and see if any of the posts help you layout how best to store your data to minimise redundancy.

On OnFocus, try requerying the form, ie me.requery. This will usually return the recordset to the beginning.

Try using GotoRecord as an event (module) on the OnFocus. Would go something like docmd.GoToRecord,,acFirst HTH

Hello Sailor, It sounds like you need a different table structure to the one you have. I would suggest three tables TblClient ClientId ForeName Surname Address1 etc TblDestination DestID City Country NB. Althoug husers might not want coutnry info at the moment, they always want data cut in...

When do you get the msgboxes? One usually only has them where you chose to put one or as a way of displaying error messages. In both instances these are slected to be there by the developer. If you get them during action queries, delete/update etc, you can turn them off either in code or as...

Wally, If I understand ocrreclty what you're after, try adding this after your If statement try adding forms!frmApplication!AppID=me!AppID

Thien, I would still strongly consider using the msgbox function and have the following as part of your on click button for the deletion, followed by the deletion code. What is the reason for not following this route as it is much simpler and quicker? strMsg = MsgBox("Are you sure you want...

If you go down a similar line to Harry's suggesttion, try Dim ctl As Control For Each ctl In Me.Controls If IsNull(ctl) Then ctl = "" End If Next ctl

I managed to resolve this through one of the better bodge jobs of my developing career. Avoid this solution unless you get desperate! I ran the code below, which created two columns, code and address. Each part ofthe address was seperated by a comma. I then pasted it into notepad and...

There are a few threads on this and at least one sample db (have a look at the one from OldSoftBoss. Try searching under jpegs. THe one thing everyone seems to agree on is not to store the image in the db. Store it elsewhere and reference it, else the db will become huge...