Search results

Check if this works: Private Sub SupplierBatch_Exit(Cancel As Integer) Dim strNewBatch As String If Nz([SupplierBatch]) = "" Then Beep MsgBox "Supplier Batch Details MUST be entered to record this quarantine item. Please enter the Supplier Batch Details Now" Me.SupplierBatch.SetFocus Exit Sub...

Can you make it a saved query and on the click event of a button: DoCmd.OpenQuery "qrydelete" (replace qrydelete with the actual name) Catalina

You can place subforms directly on the page of the tab control, so you use the tabs to go to the subform you want. No other buttons needed. Like I said, try to find some samples, they will be a big help. Catalina

Just saw a project posted on one of the freelance sites. To my best estimate it would be about 10 hours of work. One freelancer is willing to do it for $20. He can have the job, I won't work for $2 an hour.

What you are doing is combining fields of all tables in one form, you cannot add and update like that. Look at using a main form for the main table and subforms for all others. You can still put subforms on tabs, so it will basically look the same. And of course you have to link main form and...

The query you use as source for the form is non updatable. Check the link in my first post and/or do a search on this forum on the subject. There are a lot of posts handling this issue. Catalina

Can you attach the database, without relevant data, to a post so someone can have a look? Catalina

Look at the form properties, make sure Allow Additions on the Data Tab is set to Yes. Also, if your form record source is a query make the query is updatable. If the latter is the problem, check this link: http://allenbrowne.com/ser-61.html Catalina

Last summer the hottest day here was 47 Celsius. We would have loved to able to roll in the snow that day. Catalina

Lucky you, only 52 in Phoenix. We'll remember these days once it hits 110 again in July.

For what it's worth: I think Ontario is beautiful, I'm just not fond of the climate. I lived in Kingston and I loved the place. And the country side is gorgeous too.

Snow in Arizona is actually very common, especially in the northern part where heavy snow storms can be vicious A few years ago there was some in Bisbee and Tombstone, almost on the Mexican border. From where I live now I can see some on a mountain top. As long as it stays there I'm fine. I...

I was born and raised in Holland and I remember the big snow storm of 1979. Fortunately I now live in part of the world were I don't have to deal with it.

And with a few inches of snow on the ground there are less trains because of infrastructure problems that apparently can't be resolved.

I looked on Elance.com and FreeLancer.com and found that many people/businesses are looking for cheap labor from countries like India and Pakistan. I saw a project posted by someone from New York looking for an experienced full time developer for $4.50 an hour. And he got responses galore from...

You can hide the menu bar/ribbon, database window. This has been discussed many times on this forum, just do a search. Catalina

There is no need to remove the record of a lost key. You can prevent records of lost keys showing up in a form by adjusting the query the form is based on. That way you also maintain a history. If you decide to purge the records after a while you can run a delete query. Catalina

How about using 2 or 3 columns in your report. Catalina

A Google search will give you results. There are numerous applications available. It doesn't specifically have to be in Access, does it? Catalina

Duplicate post, also in Queries.