Search results

Eric Sorry but it's really not clear to me how you're going about this - for example you say you - it's not easy for an outsider to understand exactly what steps you are taking. If you can strip out all but the essential stuff and post the db I can have a look. shay :cool:

I suggest you write a query to give you the info you want to see. You can concatenate fields if you wish eg [StatusDate] & " " & [Description]. You can then create a datasheet form to view the data. There is nothing unusual about what you want to do - unless I'm missing something here! Ah...

Hi I still think you should correct the structure of the tables. If you can't have the sub-subform, why not put a button on the Activity subform which opens a pop-up form on which you could enter details of the employees and their time. shay :cool:

Hi there Try putting DoCmd.RunCommand acCmdFilterByForm in your form's Load event. hth shay :cool:

What do you mean by this? What exactly are you trying to do? Are you viewing the data on a form a record at a time? Are you wanting to print a report with this info for all non-occupied properties? The solution will depend on what you want to do. shay :cool:

Hi You will need an append query to join the two tables. The order the data is stored in isn't usually important - you can always sort data using a query before displaying or printing. hth shay :cool:

Hi Have you used the same name for the subform and for the name of the subform control? If yes, I'd suggest changing one of them. Are you sure you've included the .Form before the .Requery in your code? It isn't optional! Lastly what version of Access are you using because the code I...

Hi I think you need to modify your database structure. is an immediate flag that the structure isn't correct. You need two tables to store this information - for example, tblActivites and tblEmployees. tblActivities acti_opdrachtgever_id (the companies) acti_activiteit_id (the activities)...

No, I don't mean the name of your subform (which is what you see in the main database window). You must use the name of the subform control. Look at the Name property of the subform when you have your main form open in design mode. hth shay :cool:

Hi I don't think you stated how you were trying to accomplish this task. This should work - put =[Name] & " " & [Address] & " " & [City] & " " & [State] as the Control Source property of your unbound text box. If this is what you're already using, ignore me! hth shay :cool:

I suggest Forms!YourFormName!YourSubFormControlName.Form.Requery hth shay :cool:

Hi I'd suggest 3 tables: tblGroups: GroupID, GroupName tblMembers: MemberID, MemberName, etc tblMembership: GroupID, MemberID A simple query will give you a list of members for a particular group. hth shay :cool:

Hi I'd suggest the following structure: tblPool PoolID PoolName tblEquipment EquipmentID Equipment tblReadingType ReadingID Reading (Vacuum, Pressure, Inlet Pressure etc) tblReadings PoolID EquipmentID ReadingID ActualReading As regards data entry, I think you should create an...

Hi Your structure seems ok to me. The only comment I would make is that I think it is perhaps a bit over complicated. I would have had the last two tables as one ie PoolID, EquipmentID, ReadingID, ActualReading but I don't have all the details and you may have a good reason for splitting that...

Hi You could display the categories in a datasheet subform. Instead of having loads of check boxes, place a combo box containing all your categories on the subform then for each contact you can select as many as required. Put all your categories in a table and base the combo on it - this way...

Hi Make a query based on Table1 in which you sort the records into the required order, then use the query as the recordsource for your form. hth shay :cool:

Hi Here's an even simpler solution. Put = Me.cmbEngineer.column(1) in the controlsource of the text box which you want to display the phone number. shay :cool:

Hi I think that'd be a lot of unnecessary work if all you really want to do is display the ID and title. There isn't a restriction on the amount of code you can put in an event procedure. Try putting a text box on your form, call it txtBookmark and put the line of code I suggested in the...

Hi there Two points which might be helpful: 1. Make sure you use US date format (mm/dd/yy) in your query. Use the Format function if necessary. 2. Don't use the name 'Date' for your input date as this is the name of an Access function. shay :cool:

Hi Combo boxes can only display one column at a time. I think I'd go for the option of a separate control and put the following code in the combo box's after update event: txtBookmark = me.cboChoice.column(0) & " " & me.cboChoice.column(1) hth shay :cool: