Search results

I have got a table called tblMain with four fields, main_ID, Pin_No, DateTaken and type. And a form called CalenderForm for the month March. I want my form to populate the results after matching the pin_No and DateTaken from the tblMain with the form's textbox date values and vice versa and...

hi, i am trying to sum two fields (calculated fields from two different queries). for example i have 3 in field1 and 2 in field2, when i use tb:sum([field1]+[field2]), it gives me 32 insted of 5. here is my query snap shot pin_No emp_Name booked1 taken1 BT 0025 Phil...

Hi I am new to VBA. I have got the follwing code which is working fi9. Now I want this code to check and ignore the bank holidays as well as it is excluding the saturday and sunday. how do i do it. I Have got one table with fields, id (autonumber), pin no(text), date taken (date) and type...

hi, i am doing a holiday tracker. i am ok to enter one record at a time in a field. for exmple i have a date field and a holiday field in a table. dt_id d_date holiday ----- ------ ------- 001 01/02/2013 H but if i want to book holidays for example from...

Hi, I want to add "H" from 3 columns into a total column in a query. couldn't be able to figure it out. for example, I ve one "H" in field1, and one "H" in field3 and field 2 is blank. I used this in query grid total:count([fileld1]+[field2]+[field3]), but it wont work only give 1 instead of 2...

Hi, I am learning access 2010. I have got one main form with three sub forms. I couldn't be able to add new record in main form as add new record option is disable, I couldn't be able to figure it out. All sub forms are working ok. I have attached the database for a look. thanks

Hi, I am Kasher from UK. I have decided to learn access vba programming. I have no experience of programming, but I am fully comitted to learn vba. All suggestions are highly appreciated. thanks:)