Search results

Thanks CJ_London, I will give that a go.

Hi There, I am trying to create a query that returns all data with a date that falls within a month of the specified date I have entered. For example if I entered a date of 11/11/2016 I would like the query to return all records that have a date equal or between the 11/11/2016 and a month...

Hi Minty, Thanks for your reply. I don't want to reset the value back to Null via code. While on the form I would like to erase the text in the combobox and have an after update event that checks if the comboboxes value is Null and then i'm going to make a button visible based on if it is Null...

Hi There, I was wondering if it was possible whereby when you delete the selected text out of a combobox it returns the value of the combobox back to Null. To put it in context, I have a form with a combobox which when the form is first loaded the combobox is empty (Null). Now if I choose a...

Hi pbaldy and plog, Thank you both for your replies. You have solved my issue for me. In answer to your question plog, I am using an Access Report Object. Many thanks, Dom

Hi There, I have built myself a form where I can choose an office from a combobox and date range from a textbox and then run a query that generates a report to show all records that meet that criteria (see attachment for a screenshot of my query in design form). What I would like it to also do...

Hi CJ_London, Thanks for your reply. That has worked, cheers. Kind regards, Dom

Hi There, I am trying to create a form where I have two comboboxes to filter through records and then show the record details in the textboxes below. The first combobox sorts type (in my case cloud storage type dropbox etc.) the second combobox will then only show the associated usernames to...

Hi Missinglinq, Sorry I completely missed your post. Thank you so much though that solution works perfectly.

Perfect works like a charm. Thank you very much.

Hi Minty, you would be correct with the control source for the website name combobox being set to websitename. What would you suggest I change this to please?

The forms recordsource is set to tblWebsitePassword.

Minty I ran the combobox wizard and asked it to populate the combobox from the table wizard if that's what you mean by lookup field?

Table is called tblWebsitePasswords. Within the table I have 5 columns: WebsitePasswordID, WebsiteName, URL, Username and Password. On the form the combobox displays the website name and you can select one which in turn updates the below 3 textboxes: URL, Username and Password to show the...

Hi There, I have a really simple form whereby you chose an option from a combobox and it populates the 3 textboxes below with the matching data in the table. Now every time I select an option from the combobox it renames the field of data in the table with a number. By the looks if it, it is...

Hi Ranman256, Thank you for your reply. That would work but I would like to try and keep the form as clean looking as possible. Surely there must be a way to make column 2 show and not column 1? If I think about it column 1 has taken priority over column 0 but is that because its width is set...

Hi There, I have a combobox that has three columns, one of which is hidden as this contains the primary key. The other two are both visible when you drop down the combobox list which are 'dept code' and 'office'. However when I select an option and the list retracts it only shows one of the...

Thank you plog and Cronk for your suggestions. I will see which one works best in my situation. Galaxiom you're quite right and I will remember for next time.

Hi All, I am trying to implement error trapping to prevent errors or incorrect data from being entered. The way I have it setup currently is a lot of 'If' statements for individual comboboxes to check if the combobox is a 'Null' value and if so to show an error message "Please select a value"...

Yes that has worked Minty. Cheers Dom