Search results

You can use the SQL view of the row source property, or , if you are fairly new at SQL, you can use the expression builder. By clicking on the ... beside the row source property, you will bring up the Query builder. Just remove the two name fields, and replace them with the new concatenated...

Overflow is caused by variables being assigned values that are out of range. For example, an integer cannot accept a value greater than 32,767. If you try to assign it a value greater than this, it will cause the Overflow error. Check your code and see what values are being used in each...

One solution for you would be to concatenate the first and last names in one field. Fullname:[Lname] & " " & [Fname] You would then be able to type the full name of the contact in your selection list. You could include either a comma, or a space to separate the names. Regards Duane Barker

I have also had to deal with the 24 Hour clock. I have to calculate hours worked on a midnight shift that starts at 11 P.M. Here is the code that I used to solve it. If Me![Finish] < Me![Start] Then Me![PT] = Round((Me![Finish] + 1 - Me![Start]) * 24, 2) Else If Me![Finish] >...

Why don't you add a CancelEvent command on the OnExit event if the validation fails. This won't allow the focus to change until the value is acceptable

All you need to do is add a footer to your form, just like you would in a report, and add an unbound field with your sum calculation.

When I was first designing the Database, I thought to use the Filter by Form functionality. However my company is not willing to purchase full versions of Access for every user. I purchased the Office 2000 Developers edition, and am using the Run-Time version. The Run-Time version does not...

Here is one solution you may be able to use. on the OnClick event for the checkbox, add the following code. if me.checkboxname.value=true then else dim strSQL as string dim db as DAO.Database dim rcd as DAO.Recordset 'Use the fielname that is the join criteria for your subform...

I have a Search form which I have created that is activated on a form by a command buton. This form allows the User to pick a value from a Combo Box and then this value is used for the filter criteria on the form. This works great, but I would like to be able to re-use this form for all of my...

I had this problem as well. I looked in the help files, and finally found something that was useful. I think your problem is with how you are adding your # sign. strSQL= " SELECT " & cr & " FROM tblrates WHERE ExchDate = #" & rd & "#;"

Can you not use the SQL statement itself as the Recordsource for the Report? I've never tried this, but I think it should work. It would also eliminate alot of overhead from the temporary objects.

Umm, I think that you are trying to do this in the wrong order. Try If Isnull(me.othernames) then I'm not sure what you should insert, perhaps just a ZERO?

I have also been experiencing performance problems with my database. Pat's comment about the whole database being returned from the WHERE clause has got me thinking. I am using a Front-End/Back-End configuration. I have quite a few functions in my application which return a recordset, perform...

I have a Search form which I have created that is activated on a form by a command buton. This form allows the User to pick a value from a Combo Box and then this value is used for the filter criteria on the form. This works great, but I would like to be able to re-use this form for all of my...

I had a similar thing happen to me the other day. I had a button which opened a Form, but when you clicked it, it said that I cancelled the previous operation. I knew that I had a CancelEvent command in my BeforeUpdate event on my form, and the button needed to be clicked twice for it to...

I have finished the modifications based on the suggestions I was given in the previous message. It works like a charm. Thanks!!! Here is the new problem: The Products table has a Sub-Table linked to it that also has very important information that needs to be verified. Each Product can have...

SO I create a temporary record for the product specifications. Once the changes are approved, the update can take place. This can work, but there are more complications 1. There are 2 users that need to verify the changes, Production manager and Quality assurance. Both must verifiy the...

I've been designing a Production Management system, and one of the important features is that Product specifications changed by data entry persons must be verified before they can be used in the system. The problem is that changes are constantly being made to product specifications. I need to...

The easiest way to accomplish this would be to write a simple event procedure for the OnClick event of the checkbox. Here is the code if me![checkboxname].value=true then field1.setfocus else field2.setfocus endif

You can use variables in your filter criteria. rs.Filter = "RefNo = " & r & "" Make sure that you provide the spaces between the ampersands. You don't need to use the Filter method unless you have more than one criteria. In this instance it may be easier to use the Find method. I would use...