Search results

Hi RexesOperator, The example that I posted for you last week allows you to select a record from a combo box without the need for a popup form. Why don't you use that??

Hi Oldsoftboss, The attempt you have made to do this is great. I have saved it and will modify for my own use if you don't mind. It is just the sort of thing that I need to cataloguing a load of pictures. Will let you know how i get on with it in due course. Thanks Kevin

You won't change the site id as such. What you need is a search field - often better to use a combo box to do this. The combo box wizard will guide you through the process.

I have now had a chance to make some changes to your database and the form now works. I had to create a new form so it is not too pretty at the moment but does allow you to select a customer from a combo box.

The problem is with the underlying database and query and nothing to do with autocorrect. You are using a text field as your primary key for both tables. In your example there are some lookup tables missing which does not help. I suggest you change your tables to have a primary key that is...

I would have though this was fairly simple. I would use the after update event of the tick box to change what is in the pickup text box as so: Private Sub CheckBox_AfterUpdate() If Me.CheckBox = True Then If Right(RTrim(Me.pickup), 5) <> "(O/S)" Then Me.pickup = Me.pickup & "...

In a nutshell - Yes you can

What I do is make the calling form visible state = False. When I close the form that has been called I then change the visible state of the original from to True. This saves time opening and closing forms unless of course you need to run code under the On Open event of the form. See the...

Sorry Bee, maybe I am confused about what you are trying to do. Why would you want to open the Module. What you need to do is either run a function or call a sub procedure. To run a function just type the function name into code on your form or if trying to get a value for a text box then the...

Yes you can have a mixture of functions and sub procedures in the same module. What you can't have is duplicate procedure names.

As I said above perhaps you need to look at the database design and particularly the query underlying the form. Do you really need a GROUP BY clause in the query? If you want to be able to add multiple comments (not just 2 as mentioned at the beginning of the thread) then a sub form is the...

Having joins in the underlying query will not in itself stop you doing this unless as Pat says in your link the query aggregates data. I guess you need to look at your database design and the query under the form. If you post the MDB I am sure somebody will help out.

What I do is create a login form and each user has their own username and password to the system. User details such as dept, admin or normal user etc are stored in a user table. Following successfull login I stored relevant details in global variable which are then checked in the on load event...

I have to agree totally with CEH. Regret just about to go on holiday for 2 weeks or I wuld have had a go at re-doing the database structure for you. Good luck with it.

Part of the problem (and thisi s after a only looking for a couple of minutes) is the control source of the hidden text boxes on the right of the payroll form are wrong. You have the following in the countbasic text box: =DCount("ProductSold","PayrollbyRepID","ProductSold = 1") But you do not...

But what is the problem - you don't actually say.

I managed to open the Zip file with no problem. The error is not actually in the OnLoad event of the form (access is lying a little bit). When you go into the code to compile it the error is caused on the following lines: Dim appOutlook As New Outlook.Application Dim nms As...

I accept what you say Pat but don't believe postings like this should be in this particular forum. What has the job got to do with VBA and Modules in Access?? If you let this stand it willbe the "thin end of the wedge" If you are happy for this type of posting on the forums why not create a...

I would suggest you create a new clean database and import all the objects from your corrupt database. That normally does the trick and only takes a few minutes.

If you have a table that the form is based on why do you need the data in another table? That is a waste of resources and is prone to provide poor data quality.