Recent content by KHallmark

You can also link to the tables on the other databases and then use the info the same way. without directly importing the files. This may cut down on file size.

Go to External Data tab and click on import Access button. Follow the prompts. make sure (like he said) that there are no duplicate names of files.

You will need to create a form for the main table and then click on the other table and drag it onto the form. Follow the prompts until you get to the choice to select fields or create your own and click ok. A subform is created automatically for this. Then right click on any open space, click...

Go to External Data tab and click Export to e-mail

In Excel, Click on the Data Tab, and then click on the 'From Access' button on the left side of the screen, select your database and it will go into the excel document. Depending on the number of cells in your Access table, i would reccomend you create a query with just the info you need...

go to Design, and the click on Enter Image

Go to the Format tab, Change Shape Outline to transparent, and Shape Fill to Transparent

You might want to add a save or close button to your main record entry and then click on the report. i have to click one of those or forward or back button to save the record. You can always go back with navigation buttons.

In your report you can group your jobs by client. Right click on the client's name and click group on. It will show all the client's jobs, but not show the client's name over and over.

Search by date (search boxes with buttons: Sub Search() Dim strCriteria, task As String Me.Refresh If IsNull(Me.OrderDateFrom) Or IsNull(Me.OrderDateTo) Then MsgBox "Please enter the date range", vbInformation, "Date Range Required" Me.OrderDateFrom.SetFocus Else strCriteria = "([Date...

I don't have enough posts to show the links you posted.

Hello, I am trying to create a query with client's first and last name, their addresses, city, home phone, and cell phone and 1st date of service. I want the query to only show unduplicated clients; 'First Name' and 'Last Name'; based on their 1st date of service for the current fiscal year...