Search results

might be helpful to see some code. after the update, are you sure that Me.actorName.oldValue is looking up tblModHistory and not the current value?

need more info. what do you mean, 'enhanced'? how are you trying to save data now?

SELECT TOP 1 tPrice.Price, Count(tPrice.Price) AS CountOfPrice FROM tPrice GROUP BY tPrice.Price ORDER BY tPrice.Price;

DoCmd.OpenQuery "qryYourQuery" DoCmd.Maximize

did you know...value is the default property so you can just say Me.txt_date to get the value. as for the error, when you type: Me.txt_date.Properties then add the first parenthesis: Me.txt_date.Properties( look at the intellisense - it's looking for an index, not a string. getting the index...

thanks a lot.

so, if those prefixes are schema, and they are required (seems they are here), where does the name of the sp begin? i think you're saying that it does start with the 'sp_' -- sp_foo -- is the sp. can you confirm that? which means i'll be changing those sp names. i just read again in yet...

i've scripted a db and have been updating field names, etc. first thing is, at the top of the file, two schemas and two users were created. each schema has a corresponding user (or vice-versa) with the same name. i'll come back to this. secondly, i'm looking at the stored procedures and they...

i've used various key events and the hidden txtbox trick (a la banana's post) in the past. i think the txtbox is more work (?) but effective. i format textboxes to shades of grey when they need to be/look disabled. don't know offhand if that'll work with a dropdown.

maybe the IsNumeric function can help. i guess you'll have to check every character.

thread closed. also see original thread here: http://www.access-programmers.co.uk/forums/showthread.php?t=181559

if it's a primary key you'd have to remove that first. or, you could create a new column (number) and copy the contents to the new column. delete and rename things as necessary. hth.

have a look at input mask syntax. there are also functions you can use in vba, like UCase().

in vba editor go: insert > module copy everything dcb posted (both code blocks) into the module. save the module, name it whatever you want, you can rename it later. in any form's code module, enter this next part by hand (type it in so you can see how it works): dMsgBox "title", 64...

your form might be based on a query that has criteria that asks for user input. check the query's criteria. if you see criteria with brackets -- [...] -- remove the criteria. brackets = get user input.

not sure that's a subform problem because of the highlighted parts: "You tried to assign the null value to a variable that is not a variant data type" check your assignments (slowly step through if possible and see where the error fires). it might be a bit tricky if you actually forgot to...

are tagids unique? do you have a form ready? what have you tried so far?

thanks for that.

comboboxes only show one column: the first column with a width > 0.

comboboxes only show one column. but if you join a few values together you can see them all. 3 columns: 'id', 'firstname', 'lastname' will show one of those three (the first column where column width > 0). 2 columns: 'id', 'firstname & " " & lastname', where width of column 0 = 0 and width...