Search results for query: *

Is there a way to set a primary key when writing a make table query. I don't want duplicate records in my results. Thanks

I am trying to write a query that will take a date and add an additional day, but fridays I need to add 2 days. Is there any way to identify weekends? Thanks!

I need to automate this procedure. I have a database that is updated daily then Uploaded to my Web Server. The database doubles in size daily and my upload is taking too long. Is there a way I can add a line in my macro to compact the database, once the update is complete? Thank you!

The subject says it all. I have been given a table of item numbers that are segrigated by * and non-* numbers (ie. 111 and 111*). Is there any way to just select the * numbers? Thank you

Is this possible? I am trying to send a personalized cover letter and a unique report to customers in my database (i.e. A cover letter saying here is your invoice, then the invoice). I can do this individually, but I would like to be able to send them in batches to multiple customers. Any...

Thank you for the suggestion, however, I am still doing something wrong. The form continues to return an icon.

I am following all of the help instructions to insert an OLE object into my form, however, I keep getting the icon instead of the actual image. I have checked all of the property settings and everything seems set for image content. I don't know what else to do, does anyone have any...

This action seems relatively easy, however, I have followed all of the instructions (help) and I am still getting an Icon on my form instead of the actual image. All of the check boxes and properties are sent to display the content, not the icon, and the form still displays the icon. Am I...

After installing IE5 my default connection no longer automacally dials my ISP. The "save password" and "connect automacally" check boxes are greyed out. I cannot find a setting change anywhere in internet options to correct this. I suspect that it must have something to do...

I want to set-up IE to automatically dial my internet connection when I open IE. The check box is greyed out on the dial-up window, and I can't find anyting in the properties to activate it. Can anyone help??

Thank you for the reply, however, I am not looking to convert text. I am trying to select off records from a table based on one field that contains a single upper and lower case character (i.e. A,a,B,b). The results of the sucessful query will only contain the lower case character. I can't...

I know that Visual Basic is not case-sensitive, but it preserves the capitalization where the name is declared. I have a need to capture only lower case characters in a single field. I would think this coule be accomplished with a siple query, however, I cannot find the correct syntax. Can...