Search results for query: *

I have a query that I would like to run to get how much money have we paid in a period of time. SELECT ProjectAct_tbl.StartDate, ProjectAct_tbl.CompletionDate, ProjectAct_tbl.Rate, ProjectAct_tbl.AmountReimb, ProjectAct_tbl.Quantity FROM ProjectAct_tbl; Example: Start date completion date...

All, I have a company template that we must use in reporting. I can not use anyother design. I want to see if I can use this temlate to be part of access database. is there a way to do this?

I would like to create custom autonumber that will contain the following: firstletter from firstname first letter from lastname dateof birth. John Smith 04/05/2008 JS04052008 How can I go about doing this? Thanks

Hello, I have an invoicedetail_tbl that has invoiceDetaildescription field (Memo). I see before the text some time and at the end of the text </div>. some time I see <div>&nbsp;</div> it happens randomly. Sometime, I do not see it at all. Some time when I open the form, I see it Any...

Hi All, We have several people in our office with different screen size. Some use laptops. Also, some people because of vision problems, the font size is very large and the resolution is not the same like the rest of the people. Now, the Access database we use appear different from once screen...

Hi ALl, I have been looking for classes to teach VB for access to improve my skills, but everything I see is in the .net area. Do you suggest any school or on line courses, good books. I took access classes but usually I do not learn anything new in them.

Hello All, We have several scheduler in the office who schedule for different people work orders. I want a msgbox to appear if one scheduler try to schedule same employee for different work order that falls between or on the same two dates. (startdate and enddate). It is Ok to schedule, but we...

Hello, I have a combobox that have yes and No value. The row source is Value List. The name of the combo is shippingneeded I want a message box to pop if someone chooses yes. The msg will be “Call shipping dept at 222.” If no, then nothing happen. I truly value your suggestions!!

Hello, I have the following codes in the load event. If the purchase date field is not null, the user must choose something from the combobox (shipping needed). Right now, the box pop up but if we select Ok in the msgbox, it close the form. I want to be able to have the cursor set in the...

Hello I have a calculation formula in a field, [workdays]-[offdays]-1. the result sometime shows negative number. I want to include in the formula if the total is negative, the result will be zero. Any Suggestions!!

How can I group records for the same EmployeeID that falls between any specified dates? For example: an Employee may travel from Boston to New York and from New York to Maryland and from Maryland to Boston as final destination. The start work day is 08/01 and the end work day is 08/05. Travel...

I have Purchase date field in the database that is not mandatory field. But I want if someone write a date in this field, the combobox under it for Yes and no to be mandatory. Any suggestions

I have one listbox dependent on other. I want to be able when I click on the the row in the first list box, it shows the records related to this row in the second listbox. Right now, it will not do it unless I click on the second listbox. Note: the listboxes used to be combboxes depoendents. The...

I have been working oin this report for a while. It works now butI need the following codes to make the box grow to match the start date and end date. right now, it grows according the number of days. Instead, I want the trip total days to show in the timeline showing startdate and end date in...

Hello, I have two tables Events_tbl and Traveler_tbl. The relationship is one-many. on a monthly basis, I prepare a report for the month events. I want instead of having each traveler's name in one row, I want to be able to group all the travelers in few rows. to be clear, the report now is...

I need to create a query to obtain manager approval. We have several managers in our office and each manager has several staff who request several payments to several vendors. I created a query that the managers can run with parameter to show the records that his staff entered so he can approve...

I have a database that reside in the common drive. I did not slplit the database. It is used by multiple users. it has not reached 10 users at any given time. I would like to pprevent any user from accessing the tables directly by pressing f11 or by pressing the shift key when strting the...

, I want to count the days between two days and exclude the start date and end date in a report Example, Start date 01/01/2008 and enddate 01/03/2008 the result will be 1

Hi, We have several vendors who submit invoices to us regularly with invoice number and sometime without invoice number. In the case we have invoice number, in the invoice number field (text), I want to be able to have codes to check and see if the invoice number and the providerID submitted an...

I have a staff_tbl that I would like to add field in it with everyone's electronic Signatures for later use when they need to print the Signature in the report. I will scan everyone's Signature in a secure folder. I want to be able to select the name from the combobox and the Signature will be...