Search results

OK, I'll give you the lecture first, then try to help. If you can always create what would go into Column C by combining bits of stuff from A and B, you should not have a Column C in your table at all. Period. Just build the "C" data when you need to use it, whether that's on a form or in a...

What do you want to do if there is no reading for the previous day? One option might be to put the data into a recordset, then use the FindPrevious method. Try using the VB help, not the regular Access help.

Are your forms' Modal and Popup properties set to yes? Have you turned off the Control Box, Min Max, Close and What's this properties for your forms (or found a combination you like)? You can also create a blank Menu Bar to shut down that option for the users.

Put an asterisk on both sides of the search field: where = where & " AND [Productno] Like '*" + Me![Productno] + "*'"

In Access help, look up, "Group records in a report"

If you just need the month and year, and are happy with determining that based on the current date, you don't need any kind of global variable at all. You can just calculate this and use this in your query criteria. But, if it isn't something easily calculated, then if you are new to Access...

Instead of having the users enter a parameter for each query, set up a field on your form that the users can use to type in the data. The query needs to be changed to point to this field. Once that's working, add a new button to print all the reports. If your not a VBA whiz kid, just put a...

Hmmm, that there is obviously some characteristic about your data that you want to bring into this sort. Your custom order isn't random, right? You know what it should be... Remember that you can sort by a field that you never print. And you can create fields in your query that you can use...

First of all, have you tried a compact and repair on this database?

There's probably a more elegant method, but here's what I would do. Write a query based on the view, showing only the patient info with the latest start date (using the MAX here). Save this query, then use it in your final query, instead of the table view.

Are you using parameters in your queries? They can drastically cut the number of queries that you need to create. You should also take the leap and look into learning VBA and how to create pass-through queries. Definitely worth it.

Here's two that someone gave me...no warranties expressed or implied here: Function BlankFormControls(f As Form) ' ' Copies Null to all fields on a form - ignores errors ' Dim i As Integer, C As Control On Error Resume Next For i = 0 To f.Count - 1 f(i) = Null Next i End Function...

OK, wait a minute...why can't you use the combo box in option 2??? This shouldn't be a problem... Also, why avoid queries in the first place?

OK, you aren't going to create any update queries. What you are trying to do (if I read you write) is simply report the information that is already stored in your table. From you description, you really are looking for two separate reports. One will show products by customer. It doesn't...

Hi, If you use a SQL pass-through query, you can write as much (or as little) of your query in code as you like. This is extremely flexible, but requires some VBA skills. I usually store the query front-ends as separate queries (qCFY_Front_End, qMTD_Front_End, qPFY_Front_End...) so this method...

Look up "Like" in Access help. That's what you need. By the way, the wildcard character is *, not ?

I think that maybe your users belong in plain vanilla Access. Especially if they need to define field types or what have you. Normally, you set this stuff up for users, because it's assumed that you understand the best way to do this from the system's perspective. You would be able to protect...

Welllll.... You could set up a public variable: Public strWhichForm As String Then, each form always sets this variable: strWhichForm = Me.Name And your menu checks it (before it updates it, obviously...) to see where control came from: If strWhichForm = "fSomewhereElse" Then...

Hi, I use Access2k & Groupwise 5.5. It took us weeks to get to what we felt was the best method. There actually are several ways to do it. Here's some ideas. 1. You should be able to do use SendObject in a macro or from code. This always gets us a prompt for the GW "profile", so we don't...

It seems to me that the only way to do this would be in code, and a lot of code, at that. For each of your 30 queries, you'd need to put the results into a recordset. Then you'd need to open Excel, and using the the Cells and Range properties, do a CopyFromRecordset. Anyone else have an idea?