Search results

i can see those buttons but most of them are greyed out. The only shape I can see is a rectangle so I presume this is my starting point, but then i am lost. I could be wrong, but i'm sure last time I used access there was a choice of shapes to insert

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...

as far as I am aware you can only apply formatting to an object using that same object as criteria (I'm here looking to see if I am wrong). I would place a text box as described earlier with code, or control source "= check1 + check2 + check3" if all 3 are unticked the result will be 0. all...

the dcount thing worked, tyvm :) indies is actually a table and the code has been working fine for 10 years. I made some changes to the database recently although I didn't touch that code it stopped working. the old backup version of the database still works fine!

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...

put this code on a button... DoCmd.OutputTo acOutputReport, "Reuse_Invoice", acFormatPDF, "e:\" & Me.Combo0.Column(1) & Me.Text2 & ".pdf" Reuse_Invoice is the name of the report. after acFormatPDF, is the part u are asking about. here it simply builds a string e: is the location, combo0...

I've done exactly this to keep track of volunteers. 1st create a form for the month (mine moves dates around according to days and hides 31st when necessary). make a listbox for each day. each listbox can be requeried for exact date when necessary (on load, changing month on calendar). I have a...

i would calculate the number of minutes between start and finish and then just tot them all up. easiest way would be to have 2 fields, 1 for hours and 1 for mins. something like... worked = ((finish_hours - start_hours)*60) + (finish_mins - start_mins) / 60 start with a query selecting all...

create the report with a sort order and then copy it and change sort order on each report. then just open whichever report matches the chosen sort order, perhaps with a select case or if then statement. makes a bit of clutter with all the reports but quick and simple

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...

when I was using access95 I found that copies of the database often got buggy. compiling the database usually fixed this. although it doesn't sound likely, maybe the link is dodgy. e.g I often end up with a front end linked to c:\databases\ when on other pc's it needs to be \\...

solved this myself while trawling other similar probs. all I want to do is check weekly lottery numbers against our chosen lines at work. Access only allows 3 cf's while excel is limited only by memory. it took me 5 mins to set up a decent looking spreadsheet! silly me for not using excel in...

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...

its a number field to check our staff lottery each week.... so i have 10 records of 6 numbers on a continuous form. i enter the 6 winning numbers on the header of the form and am trying to get any matching numbers to highlight e.g change the backcolor

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 :)