Search results

Hi Access peeps, I am looking to make my database faster Some information: The database has about 10,000 records (and growing). It has one main table and the users front end is split from it - they access it across a enterprise LAN with nominally about 5 users at a time in the DB. The...

Yes so a log of the assignment history will appear in the subform and I need to add controls to dusplay current assignment as well as a field to assign new user. I guess there is no reason I cant put this all on the subform. I will let you know how I get on. Regards, AG

Hello, I have a form based a recordset of TableA which is a list of Events. The Form simply displays the current event in the recordset and there is a dropdown where the user can select what happens to the event. If a Value 'Intervene' is selected on the dropdown where you select what happens...

Yeah thanks. I think it was that I had not set the child fields etc. Running very nicely now - thank you. Here is the code for the benefit of anyone reading in future: Private Sub btn_enter_new_note_Click() Dim strSQL As String Dim db As DAO.Database Set db = CurrentDb...

Ok, I am a bit lost: my main form displays a record set based on a query on the main table. The subform shows the notes log, and I can add to it with a button. But when I navigate to a new record in the record set the report in the subform is not updated. I presume I need the report to change...

The text field to add new notes.....was it on the subform or the main form? Also is your main form based on a query or is the data source set to a table? Else how did you get access to fields from different tables? Cheers Al

Thanks - thats nice and pretty much what I am after. Will give it a go ;)

I understood most of what you said except using a report in a form which I can research and the hidden controls which I can also research.. Dont suppose you have a form I can look at? Cheers!! Al

Thanks Paul. Thats totally my approach in terms of the data. What about the layout of the form? Just a text area?

Hi People, I am after some input on how I should design an area on my form for a log style window of notes. what I am after is a scrollable readonly text area with another text area below that is not read only where people can append further notes to the log. The read only area should have not...

Yeah - I agree - but thats not my call. I dont think you have all the functionality from Access you would have from Outlook - for example I dont think you can monitor for new emails from Access?

I think it might be to do with a (group?) policy at work - but its weird since I can do it manually. I know that the group policy does stop scripts in outlook, but scripts in Access are fine, and we can send emails using references to the outlook objects. Will let you know the outcome.

Thanks but - Reply recipients is not send on behalf of - its setting the reply address.

Yes, since I posted that message I tried the same code on a standalone in Word (it doesnt have Access) and it ran ok. I think it is something to do with our build on the work machines. Interestingly I *can* manually set the reply to address on our work system, but for some reason via VBA...

Yes - that is what I am talking about it. Do you have a good tutorial on this approach or able to offer any more detail?

I am in MS Access 2013 trying to set the Reply To address for a olMailItem with Outlook 2013. (https://msdn.microsoft.com/en-us/library/office/ff862985.aspx) My current code is giving me: Run-time error '287' Application-defined or object-defined error Private Sub email_button_click() ' ***...

Thanks for that. I see how you could split it out. Could you not then create a view which allows your queries to see data in the same table structure its in now - thus avoiding the need to reedit all you objects/queries etc? Cheers -Al

Ok, I admit it. I made a seriously bad design choice and have ended up with a flat table that now needs to be split. Basically the incident table has fields to capture the basic details of a event: Date Time Address Incident Number And on the same table: Surname Firstname Address Birth Date...

Hey thanks for all your help - I think I found where the QueryDef was getting changed and I have fixed it. In process of testing now - your right - it was somewhere else. Regards, -Al

I can not for the life of my find out why the Querydef is changing (but needless to say it is) and the event that triggers it is the emailing of the report. Is there a way to load a "watch" as it were on the querydef? Cheers -Al