Search results

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

I'm glad it works for you. But looking at some of the forms that people made (RossWindows esp>), mine is cheap and basic.

Nothing that simple, unless the designer did a fantastic job with the Relationships Table. My approach would be to go to each control and check for either vb code or a macro that it uses, or data that it references. Your best bet would be to check the command boxes first since they tend to do...

Here is something that I hope can help you. Its a very basic development, but it should point you in the right direction. I converted from 2007 to 2000 so if there are compatibility problems, let me know.

Check your links because they don't work for me. My first question, "Credit Note Value" is that generated then automatically put in the form, or does the user enter it into the form? If the user enters the value into the form, I would double check the query that reads off of the form, make...

Well we might as well start a daily countdown until this thread is meaningful again. Happy unbirthday Ken, only 179 Days to go!