Recent content by alktrigger

Intern, College (yes, separated by a comma) I do whatever I am told, and recently that is very little, so I frequent AWF a lot. I did learn how to use Access on company time, so that's been nice. Maybe one day I'll get a job that involves mechanical engineering... so that my current degree path...

I love it when people use the search function! good work nharrison

The next step is to sort through kryst's posts and see what small personal details we can use to identify more specific details, then we can have a surprise bbq next weekend

Pickaxe.... check Shovel.... check sunblock... check beach towel... check umbrella... wait... something seems off

Kryst: Must be nice working for NBM in Houston, TX... thank you lord Google for allowing me to use menial information to locate the lost souls. The loser can always get the girl by being awkward, persistent and creepy.

i pulled the following from a macro in word, you might need to adapt file location and the Active document part ActiveDocument.ExportAsFixedFormat OutputFileName:= _ "C:\Documents and Settings\My Documents\Doc1.pdf", _ ExportFormat:=wdExportFormatPDF, OpenAfterExport:=True...

This is somewhat long and tedious, but you can format excel from access. Here is my code for exporting my reports. Function fcnExportReport() Dim strWorksheet As String Dim strWorksheetPath As String Dim appExcel As Excel.Application Dim sht As Excel.Worksheet Dim wkb As...

I'm trying to create a query that will update as a textbox is filled, but if there is nothing in the textbox I want it to act as if there is no criteria IIf(len([Forms].[frmMembers].[txtLastName]) > 0 , _ InStr(1, Left([Forms].[frmMembers].[txtLastName,_...

Here's how I would go about it. I would make 2 queries: Query 1: qryTempBook (change the names) SELECT tblBooked.SalesPersonID, tblBooked.CustomerID FROM tblBooked WHERE (((tblBooked.BookedDate) Between #8/1/2009# And #8/31/2009#)); Red - Change this to whatever control you are using. Query 2...

Using this method will allow you to keep records of who used what rooms over a long period of time. This can let you analyze specific customers and potentially use this database for marketing/promotions/customer loyalty. But as for "setting up a record for each room" would be nearly automatic...

Could you attach an empty database so I can take a look at it and see if we can diagnose this problem?

Here is how I would go about it if I knew that there would be a lot of different contact information for various contacts. It's not in-depth, but it allows for separating addresses and phone numbers as private, business, fax, etc. Hope this helps.

did you get the database from the internet or did you use the "create new database" template section of access. if you're using it from the internet, you probably opened the file without saving it to your computer. if you used the template section, as long as you saved the file, you should be...

Sure, here you go