Search results for query: *

I currently export an MS Acess crosstab query into excel spreadsheet, in order to calculate total hours worked by each employee, every week. Time format within each field is similar to numbers e.g, 0.32869213. Formatting 0.32869213 into short time within excel, hh:mm, equals 7:53 (7 hours 53...

i have designed a crosstab query from a table with fields containing DATETIME datatype, to produce a report showing employee start time, and end time, for sets of specified dates, e.g "Current Week". here is my query: TRANSFORM Sum(Format([Logout Time]-[Login Time],"h")) AS HoursWorked SELECT...

hi all, I have a SELECT query (qryReport) based on two tables, tbl_Customer & tbl_Order, I am using this query to generate a routine calculation, of total cost and profit, from periodic sales transactions. I also set up a form, with two textboxes and a button, for users to enter dates and...

Hello all, I have an application running on Access 2003 version, installed on a shared network folder. The database is accessible to more than 15 employees at a time. We have installed the full version of Access 2003 on all workstations. Therefore, i don't believe it's a reference or run-time...

Hi, I have a form containing 5 option buttons, to check for series of specific validities, 1 command button, and a text box to display validity notes. I would like a user to select an option by checking the option buttons, then click on the command button, and place a note inside the text box...

Hi, I have a form containing 5 option buttons, to check for series of specific validities, 1 command button, and a text box to display validity notes. I would like a user to select an option by checking the option buttons, then click on the command button, and place a note inside the text box...

How do i convert the "Boolean" Datatype in a Make Table Query pls?. I set up a make table query, based on a table which has one of its row data type as Yes/No. When the Make Table query runs, i noticed the results inside the Yes/No fields appear as 0 or -1. How do i convert this field within...

hi I am new to Access SQL query. I have a table with the following fields & data types. Fields Datatype ReadDate Text Micro-Business Boolean or Yes/No I'd like to design a query and update some data within this table, based on the...

hi I am new to Access SQL query. I have a table with the following fields & data types. Fields Datatype ReadDate Text Micro-Business Boolean or Yes/No I'd like to design a query to update some data within this table, based on the...

I am trying to publish my database to web, but the "Publish" option button is grayed out in Access 2007. How do i enable this, pls assist. Thanks

i have a listbox control placed on a form, "frmEmail". Users can select email address and click on a button to send email to a selected contact. I keep getting the above error, on these lines .To = strEmailRecipient .Subject = StrSubject .Body = StrBody .Display kindly assist...

I have a query which update on a daily basis. and i am currently using the Docmd.SendObject,,,"MyQuery",,,myname@mail.com,,True. To email this query to some managers. the criteria of the Date field of "MyQuery" is set to Date()-1. This ensure previous day queries are emailed out the following...

My question is based of Access Database. I have an application that calculates total hours and breaks for employees within my department. The database has an action query, "QryTimesheet". This contains three calculated fields, and the criteria i used for displaying results are: Total Break 1...

I have an unboud listbox control, placed on a form, it collects membership informations e.g firstnames, lastnames & Membership Numbers from a query called "queryFindMemberWildcard". I would like users to select a member from the listbox by double clicking a MemberFirstName or MemberNo. Then...

Pls assist, I have a SQL query with wild card criteria. I am Using the SQL with VBA Codes. I want users to type in values into text boxes on a form, then populate a list box with related values (if available) from query results. I am getting the Type Mismatch error 13 when i do the search...