Search results

That would be ok if query was only accessed by the one form. But the query is used in several ways, and cannot be based just on the text box in the form I am referring to here. I think if I am going to develop this link I will need to design another form based on a modified query as you...

I have abandoned this approach now. Instead I have decided a hyperlink from the txtBaseName field to the other form would be better. The other form frmDailyCallSheets has a combobox which is the control for a parameter query that is used to select the base involved. I would like to apply an...

Let me see if I can put this properly. I have a form which displays information on clients related to a particular "base". In the header of this form I have a calculated field which displays the number of clients who are due to receive a call today, which is obtained from a query...

Thanks jdraw. That may be the problem. It may be as simple as some minor error in the coding behind the table or query or form itself that doesn't register as an error but affects the operation somehow. This object is new to the database and is still in test mode alongside a manual system...

Mmm. No such luck. Still taking a long time to refresh. It's not all of the time, just occasionally. Some times the form refreshes in a couple of seconds, other times it takes quite a long time. The issue might be our network, but this is the only form that consistently performs so badly.

I just had a look at the source table and noticed something odd. The first record was blank. I deleted it, and it seems that this might have fixed the issue. I'll wait to see what happens :)

What would you want to see? It is a fairly simple form with a list of locations in text fields with associated fields in the table for various options in comboboxes. The comboboxes are form based, not lookup fields in the tables. The checkboxes are simple Yes/No fields with no programming...

The database is split with all tables in a back end and each user with a separate copy of the front end.

I have a form with a list of locations that we use to show which have checked in and out every day. I have check boxes for each record for this purpose. One problem we are encountering is that if one user checks one of these boxes, it can take a very long time for this to show on other users'...

Works perfectly! I had the elements but the formatting got me (again!) Cheers! Steve.

I want a form to display the following month and year in either a label or text box. The form is based on a query that filters a date range to the following month's dates so I want to display the month and year in the header. I just need the correct function for this.

Sorry for the multiple posts. I have worked out the system file thing. It was that I had hidden files checked on in the navigation pane options. Ok, so now it's just the other things. :)

Actually there is more to your little db than meets the eye! I looked in the relationships pane and the tables you have there do not show in the object navigation pane. This might need a bit of explanation. I am a relatively low level developer and this is new to me.

Actually arnelgp the db does need something else. What I need to be able to do is to show the roster dates for a full month per location. The main form should have two comboboxes. The first, a combobox to select the location, and another to select the month, (or the other way around), then the...

Thanks once again arnelgp! That has everything I need. I admit I don't understand all of the code and that makes me nervous. If you have time would you mind sending a PM with an explanation of what each line of the VBA does? If not that's ok, I will study it out. I just don't like copying code...

Can't seem to open it here at work arnelgp. Security! I'll have a look at it at home.

Ok here's what I'm thinking at present. I could have a form with a combobox which selects locations and a list of dates and other relevant details for each location, which are saved as separate subforms. There are about 25 locations. I could also set up comboboxes against each date which...

Hello all. I have been asked to develop a couple of rosters to replace ones we have been using in Excel. I am having trouble with this. I thought I could simply develop a query that brings a table with e.g. volunteers and another with a date list and generate a monthly list of dates per...

This happens to me all the time! After some head bashing the answer came to me. The answer was to create an update query to set the Yes/No fields to No and the Text fields and Combo fields to Null. This update query will run after the append query saves the changed values to the history...

It is a bound form but I only use the form to temporarily record activity that will be saved to another table as a historical table. I have not tried using an unbound form to do this. I have a table with a fixed number of records called tblBaseSignInOut. It is used to log when remote locations...