Search results

Here4Real: I was confused at first due to you describing 3 tables and originally I only had 1. The database was very useful as it prompted me to firstly tidy up the new tblDrpEnqOptions table (so now has PK, Current_Status_no, Available_status_no) and link this last column to the PK of...

the combobox now updates on focus so the dropdown list reflects the options available (based on the current status textbox) but only shows the 'new status' column from the previous posted table image. The short/long/full description columns all appear blank?

Thanks for the feedback, as in the previous post I have found a way to do this (which is as Here4Real suggested) and now having an issue with what appears in the columns of the combobox (only the ID number appears, the other selected columns are blank). If I could get some guidance as to where I...

Thanks, I seem to be getting somewhere. Probably a minor issue but is not obvious to me, the combobox now updates on focus so the dropdown list reflects the options available but only shows the 'new status' column from the previous posted table image. The short/long/full description columns all...

Might have a workaround which has bought up a different challenge... I have created a new table (tblDrpEnqOptions) which links the ID field from tblDrpEnquiries to a range of available options (see attached screenshot). Current_status_short and new_status_number are both data type "number". I...

Not sure I have done this correctly but a basic flowchart is attached. How do I then import/input this into access, struggling to find any reference to this from my searching?

Thanks for the suggestions. Jdraw, never used flowcharting for access so not sure how this would work? The suggestion of using a query at first glance seems to be a workable option (my view is if it is all in access vba then there is only 1 program to go to if there is an issue - as it will be...

Exactly. Each customer/job record has a current status (all start with "8", their progress along the supply chain here will result in them being given an updated status). Would you know how I would code this? The combobox is "cmbstatus" and in the background is also the table field it links to...

Hi all, not sure if this is best suited here (I anticipate it needs some coding!) or in the forms section, sorry if wrong! I have a combobox with 13 options. As the customers order is processed I would like a user to be able to update the status based on its current status. E.g. current status...

When I tried it without the # or format it reverted back to the issue I had before, where the day was staying as the 2nd, but the month was increasing (feb/mar/apr etc). I do think that I need to go back through previous forms code and make sure that what I have picked up from you guys is...

Thanks It is more than just the past 7 days. The users are able to add in notes/comments on a day to day basis about their current tasks. We will need to store a record of these and so it needs to add a new row each time. On another form they can amend the 'no notes available' to whatever is...

This works really nicely. The only problem with it from here is that dates are added the other way around (i.e. insert todays date, they yesterdays, then day before etc) so in combo boxes on other forms and reports the order does not flow. I have edited the code to this which seems to work well...

Thanks for the code there CJLondon, that works! Is there a way of it stopping once it has added todays date, as it appears to just keep going into the future otherwise?

hmm..that auto formats itself back to strNowDateThree = Format(Date - 3, "\#MM\/DD\/YYYY\#") which gives the same error? Ive put in a msgbox to show each date line individually (and the date posted to the table) and get the following: strLastDate = 30/01/2015 (30th jan as per last...

This gives me a Run-time error '13': Type mismatch

Have found an alternative way of checking if today is in the table already so I can now use the 3rd option when creating a combo box, so the fields now update as they should, thanks for your help :)

Trying to create a record in a table (tblToday) for any dates in the past five days which do not already exist. This needs to include the previous 5 days for other forms/reports to function correctly. The code below is the simplest way I could work out how to insert multiple rows (on a row by...

Hi Jdraw If I re-explain hopefully I can word it better this time around! It is just 1 form with 4 fields: txtDate - unbound, format short date txtComments - unbound t_date - linked to t_date in table tblToday t_comments - linked to t_comments in table tblToday My aim is to have 1 form where...

jdraw That works, I have dummy data in 2nd, 3rd, 4th and 5th feb which appears when running that query.

On change event as I want the t_comments field to update straight away, as opposed to tabbing or a button click. The recordsource is tblToday, which is where all the data is stored.