Search results

Hello, I have been searching all over for an answer to this, and so far found nothing. The date variable in VBA can store date and time together. So to make my table smaller and easier to modifiy I have decided to store date and time values in the same feild, using textboxes to 'extract' the...

Hello, I am getting rather fusrtated - I have built a form including 2 comboboxes. the frist combobox uses an SQL query to select rowsource from my master table fine - however the second combobox recordset will vary depending what is entered in the first combobox. I have written a marco set in...

Hello, Not sure weather to place this under from or query thread. Could somebody please point me in the right direction - I have a form with a textbox, in this texbox the user enters to ID number of a product. I would like when the users hits the enter key, to open the 'edit' form showing...

Hello, Recently I came across a database where - on open, only the main swtchboard form appeared on screen. This was minimized to the center of the screen, and the usual access 'grey' background was minimized onto the taskbar. A user could maximise access to get to the edit tabs, but tabs from...

Hello, Well - before i kick off - I am very much aware that this is both silly and non time effective, but I'll give it a go if i can. I have a rather complicated Excel workbook - in a nutshell the user selects a costomer and enters in a tonne of purchases and variables using several...

Hi, Have searched all over but cannot find. Is there a way to apply a conditional format if field value is not more than 1 value. For instance I seem to remeber there being an IsNot statement along with an OR statement, however this does not seem to work with conditional formatting Thanks

Hello, I have a VBA macro that runs an update query based on user entered values on a form. I keep getting an issue related to date formats - where date values are all in UK format "dd/mm/yyyy" for all tables and forms in the database however, when the date entered in the form is put through...

Hi, I am creating a database that requires a user to link a file to a record in the database. To do this I am currently using an update query, The user manually 'copy as link' from the file and pasting into the update to field. The issue is - Copy As Link adds "'s before and after the link...

Hi, Never posted here before. I'm pretty good as an excel user so thought writing VBA for access would be the same. However i've become pretty stuck. I have a single table for all the data in my database, and a number of forms that users can use to edit this data. One of these froms is a...