Search results

yes I am using access 2007 however it appears odd that this only occurs on SOME boxes and not others.

I have recently been getting the same issue on a form I use, I also have no idea what it is either but it appears to not prevent or stop anything in my form at least.

If i select some combo boxes and then select away from them, they appear to go transparent (or grey seeing as my background is also grey) The real problem is that there are some that do this and some that dont and i dont know why they do or dont change color when i unselect them. Is there a...

Private Sub btnaddsupplier_Click() On Error GoTo Err_btnaddsupplier_Click Dim dbs As DAO.Database Dim NewSuppl As String Dim InsertSQL Set dbs = CurrentDb If (IsNull(NewSupplier.Value) = False) And (NewSupplier <> "") Then NewSuppl = NewSupplier.Value Else MsgBox "New Supplier Box...

This helps in some sense. This box now creates records however there are some issues i have with it... firstly if i create a new supplier it adds 1 to the last ID. I currently have 9 test items in the list and if I add 1 it will become the 10th ID. If i then delete that 10th id and recreate it...

this is very similar to what i need to do however I am so new with access i dont really understand how to do that... If i can get what you are describing to work, I can modify it in order to also show the current list of suppliers as well. is it possible to explain how I can do this? sorry for...

I have changed that to "INSERT INTO" however I am still not getting an update into the table and im not sure why. in the table "Suppliers" i have 2 columns, one column is ID and the other is Supplier but i dont think i need the column "ID" it was just a number I could use to check what number a...

Hello, my name is Penfold and I am from the UK (about 2 hours away from london) and I have joined here to gain more knowledge on access but more specifically coding and programming. So, i have a job doing odd automisation jobs but Im not a programmer even though I wish I was! I have a strong...

Hello, Im a little bit sad and frustrated that I cannot figure out what the problem is by myself but i got to my limit so ill post here hoping to get some help :) I have a form which links to a bunch of different tables for various reasons but one of them is called "Suppliers" (theres a drop...