Search results

Hi Guys I am fairly new to designing databases and so far the wizards have been great, I am told to avoid the wizards but when you are clueless they work fine. The database: I have designed a database that contains 2 tables linked via the customer name field. The first table is the client...

Hi Guys I have a db that after opening the main form gives the option of entering a booking for a customer already registered. So on the bookings form i have a lookup combo box running to retrieve the name from the client table this bit works fine. I have then created text boxes to enter...

Hi Guys Can anybody assist with the dimensions to set a form to print on an A4 sheet please. ie - 1 record one page, i know its a simple print command button but it keeps splitting onto 2 pages. Cheers Guys Anthony

This only changes the amount of forms shown on the page. What is happening is when i enter values in time format 07:00 with the text box format set to short time the equations work fine, the problem is that when i then go to a different day (record) the values from the previous record follow...

Hi All I have a very simple database to record mileage and work times etc. I have set up 3 text boxes, one is to enter start time and the other is to enter finish time, the in sequence the 3rd box gives me the difference between then using =Val([Text48]-[Text46]). This all works fine except...

Hi Guys i have created a table and am trying to run a qry that counts specific data, i have been searching but cannot find the answer. I have a standard qry that has the criteria of "staff name" and dates between ## And ##. Now when that information is returned, how do i get a count figure for...

Count function returning no data Thanks for the help rsmonkey however when i do this is returns no data This is what i have Field = BC Visits Table = All Work Plans Total = Count Sort = (empty) Show = Tick Criteria = Like " * September * " When searching this manually there are 56 entries...

Totals Query Hi Neil Many thanks for the reply, i wasn't aware that you could do that in access, and have got little experience with access. (First DB to be honest) but it was better than working of 24 different spreadsheets. I know this is a newbie question but have you got any idiot...

Hi Guys I currently have a database and the powers at be want me to enable a button that will count how many times in the database a particular month is used. So for example how many times did we visit a particular place in September/october etc. Is there a way of doing this that i can't see...

A deeper explanation Thank you for the welcome and yeah i have tried disabling the menus in the startup options. The main reason is that although the database will, once rolled out, be our main work space for data entry, other users are moaning that they still need things on their desktop and...

Novice needs idiot guide advice :-) Hi Guys I am a new member to this site and have been trawling for the last few days searching for an answer, which i think i have found . . . the problem is i don't have a clue where to start. I have developed a database for work and during its first week a...