Search results

Hi, Trying to delete records on table SBSales where the date on the record match a date found on a record on table SBSLSPR30. For example delete records when SBSales.SaleDate is found on SBSLSPR30.[Date]. Whats the simplest way to accomplish this.

Hi, I am trying to create a query that will give me the total sales of each item col 1 based on 7 days, col 2 30 days, col 3 60 days etc. My simple table has fields, "Item" "SaleDate" "Qty". I did it with the crosstab query worked great using Date: Partition(Now()-[SaleDate],1,90,30) but i am...

Hi, I would like to export a filtered report to excel. The report is based on query that has lots of fields, but I use the strwhere to open the report with specific records only. When I try to use the DoCmd.OutputTo acOutputReport, "QryTrn", "Excel97-Excel2003Workbook(*.xls)", "", True, "", ...

I searched and searched but cant seem to find this anywhere. I have a parent table called customer name that has ID name phone etc, then I have a orders table with 3 fields in it Order ID (autonum), Customer ID, and order date. Now I would like to create a query with all orders from the second...

I have an unbound box on an unbound form that will enable me to put in a criteria for the report to open, the code on the click button is as follows: If Len(Me.Box1 & vbNullString) > 0 Then strWhere = strWhere & "([Name] = """ & Me.Box1 & """) End If I would like to know if...

I have a continuous form that each record has a checkbox called default. Problem is that I want only one record to be the default. So basically I would like when a user presses a checkbox in one record all other records should get unchecked. Or it should pop up a message box that another record...

Is there a way to export my table or form fields to a specific pdf file on my system that has interactive fields (its pdf that has several fields that can be filled in on the computer). So lets say I would like the last name to go into the Q1_Last_Name filed on the pdf, the first name should go...

I have a report that is based on a query that has 30 columns, Now of course it wont output all columns on 1 page, so I would like to have a field selection on the form that opens that report, For ex. I have Name, address, city, zip, phone, SS, DOB, Destination, etc. I would create unbound...

HI, Im designing a DB for a collage, and need a query with like 20 columns, linked together from 3 tables. The columns are as follows: Name, phone, Address, City, State, Zip, SS, DOB, Year, Grade, Tuition, Books, Payments, and so on.... I need a way to select each of the columns by 4...