Search results

I've been away from access for a few years and am now back, surprisingly rusty, grappling with office365. My problem is... I cannot insert a shape into a form. I have tried placing a rectangle, but only shape fill and shape outline controls are highlighted. So is there a shape button...

the following is adding 70 to the total no matter how many records are in the table! Private Sub Command0_Click() Dim MyDB As Database Dim MyRS As Recordset Set MyDB = CurrentDb Set MyRS = MyDB.OpenRecordset("Indies") MsgBox (MyRS.RecordCount) MyRS.Close...

i have a button on a subform that appends to a table, working fine. i have a listbox on the parent form that shows the records in said table. my problem is i cant get the listbox to update when i click this button. i have to open and close the form to display the new record in the listbox. if it...

i can do a cf with... "Field Value is" "equal to" "[text0]" this works fine. is it possible to do something like... "Field Value is" "equal to" "[text0] Or equal to [text4]" "Field Value is" "equal to" "[text0] Or [text4]" the reason i am attmpting this is because i have 7 text boxes (all...

i'm trying to apply a format to a control with more than 3 conditions. i tried "field value is" "equal to" "me.text0 or me.text1" etc, trying a few variants like "or =me.text1" without success. i can apply 3 seperate conditions using the access tool which works fine, but i need 6! can any1 offer...

i have returned to access after a long break from programming and cant believe how much i have forgot! i'm having a few teething probs and hoping u guys can help me out :)