Recent content by bibbyd01

Hi Thanks for your reply. I do have rows where the agency number is null, but these are excluded from the query. There’s no way around that as not all customer are or have an agency. The cbxCC is selected so not the problem (unfortunately). An owner could have multiple agencies...

Hi all I’m struggling on building a working report that filters out based on a calculated field. Access believes this to be because the calculation is too complicated. I will try and explain why (apologies for the length of this). The data is populated based on a customer table which...

Hi all I have a form which adds comments to an invoice record. The user can add as many comments as they like. I currently have a 'add comments' section at the top which works through some code to add comments to the table. I want to change this to run a subform instead. I have add...

That's brilliant. I didn't realise I had to do that in the query.

Hi tblZCSCost is the table, tblZCSCost_ord is the field within the table (so I know which table the order field comes from).

Hi All I have two questions really. firstly, if you have a dlookup in a query, are you still able to populate a form using the query (it's based on only 1 table, and the query will be used to populate a form which opens using criteria from another form). My assumption is that you can, so...

Hi Bob I want to view the deletions on the form, so this wouldn't work for this situation. I'm sure it's something to do with requery, but, in all honesty, it's not critical to the operation of the database so I'll keep plugging away and seeing if I can work out how to do this

Hi all I have a form which displays multiple items. I have a checkbox to indicate whether the item (an order) has been invoiced. If this is selected I want two other fields to be updated, the user and the date/time. I'd like this to happen on the form instantly if possible into fields the user...

Below is the VBA code I'm using to update the comment. I would have to make a lot of deletions/changes to upload the database but I don't think it would help. All I need to do is refrseh the data in the forms frm_WIPcomments and frm_short_WIP. Private Sub Command30_Click() Dim err As Integer...

I didn't explain that too well. To add a comment, the user opens a specific form which then adds the correct details I need to a table, before closing the add comments form. The user then returns to the comments form and I want the newly inserted comments to appear on that form. I don't think...

Hi all I have a form which inserts a comment in to a table. As part of the vba I have the below, which I think should refresh the data to include the comment that's just been inserted in to the table, but it doesn't appear to work (I was sure it did when I looked 2 days ago)...

I have found a way of copying the data now using VBA code to do this, check all fields are completed and close the form when complete.

Hi This is because I wanted the form to be an update comment form, whereby no previous records are displayed. Also, the form it opens from is from a continuous form so it had to be able to update the comments on just one order, without having to enter the order number details. I found that...

Hi all I have a form that updates comment details. It has two text boxes, auto filled when the form is loaded with the date and time. As these aren't linked to table in the form, when the record saves, it doesn't update the table. How do I do this? I assume there's something I need to enter in...

Hi All I have a form which I would like to display the last comment made against a particular order. I have a datasheet form (frm_orderdetails) which has continuous records, based on the order number. You can also add comments to a table (tbl_comments), which includes the date and time of...