Search results

In a report it lists all the days of the month ...i need to make each sunday bold . The formatting in the report is day date . any ideas ??

Simple invoice but i need it to auto increment the invoice number im using Private Sub Workbook_Open() MyInv = Sheets("Sheet1").Range("A1").Value MyInv = MyInv +1 Sheets("Sheet1").Range("A1") = MyInv End Sub it works if i run it from the vb window but not when the invoice is opened...

Hi i have a form with a subform ( displayed as datatable) the subform has 2 fields date and hrs . currently there are dates for the whole month displayed . what i would like to do is be able to forward all of the months in the dates to the next month I.E 22/7/06 would become 22/8/06...

i thik i need a total rethink ( formally Totalling) Hi i have 31 combo boxes on a report, names 1st 2nd etc for days of the month can anyone give me the proper syntax to total up all the boxes in a report i just cant get it to do it

I have a form in datasheet style .....it only has 3 columns Id ,date and hrs what i would like to do is poulate the date column with the dates for the month based on the first entry I.E if the first dat inputted is 1/7/06 or chosen somehow )it would fill the remaining dates for that month...

i have a form with 4 subforms on it informing the amount of calls etc taken and im trying to get it to autorefresh avaery 30 secs but it refuses to do it . I have folloed advice in other threads but just can get it to work.....Question do i have to set up refreshes on the subforms or just on...

i have a form with 4 subforms on it informing the amount of calls etc taken and im trying to get it to autorefresh avaery 30 secs but it refuses to do it . I have folloed advice in other threads but just can get it to work.....Question do i have to set up refreshes on the subforms or just on...

I have a query that returns the uncompleted jobs from a single table ( its a calls database) all i need is query that returns the amount of uncompleted jobs onto the switchboard I.E whatshername has X amount of uncompleted jobs , i have done a search and most of the solutions are very...

i need to make a query that returns all the records older than 24 hrs anyone help me with this one ?

im working on a little project , a call logging system pretty basic stuff but i can work out how to have the time of call recorded. the users will have the input form open for most of the time txt box i have is formatted with =now() this brings up the time the form was opened is there...

I have a report which seems to work well apart if there is more than one result for a client it has a large space as pictured ( hopefully ) below any ideas what ive done wrong here ?

hi i will ry and keep this as simple as i can i have a form which a user enters appointment dates .....i need a sloution to have an option of repeating the appointment every day /week /month for a specified amout of weeks whats the easiest solution to this one ??? cheers

Hi Well sel has helped me finish this small database and now im looking to make some cosmetic changes ... is it possible to hide access when the switchboard is displayed ........and also hide the window borders on forms etc ?

:confused: simple query Critera : <Date()-30 should show records from the last 30 days ??? and : "status"="active" should show records from the last 30 days that are active ???? or am i totally off the mark here ? vey new to this be gentle :eek: cheers

Im designing a report and i have a field Authority Number I want to put different addresses into a textbox according to what the Authority number is.... what would be the best/easiest way of doing this ??? plus : on my report the deatils are correct but the first set of records have...

hello ladies and gents as it says on the tin i have a problem .Total newbie to access and have bluffed my way to this point . i have a report that calculates time differece and is displayed as 1:00 for one hour i need to multiply this by an hourly rate .....sounds simple enough but i cant...