Search results

I have a form with several date fields, i would like only the ones that meet the following condition to be visiable: Between [Forms]![Date form]![Begin Date] And [Forms]![Date form]![End Date] any suggestions??? Thanks in advance

Thanks that worked great!

sorry,I need to calculate 3 years back from todays date

what is the correct expression for calculating the date for 3 years from todays date?

Thanks the links were very helpful!

What does the "Shrink Database" task do in the SQL Server Enterprise ?

I would like to delete some records in my database but the Cascade Delete option is grayed out. The tables are linked to SQL Server and have an Access front. I tried making some delete queries that would delete records from each table and that wouldn't work. Basicly I have three tables that...

I have an Access front end that has all the queries, forms and reports. The tables are linked to SQL server. How do i move the access queries to sql? Is Access Project the only way? When i try to link to a stored procedure in SQL server it doesnt show up in the lists like the tables do. All...

Hopefully this is a simple fix for someone who runs macros in access modules. I have code tied to a Print button that prints a different report based on which one the user selects, one of them needs a macro to run in order to generate report so i wrote this line of code for the one that needed...

I have a form with two unbound fields; Begin Date and End Date, is there anyway to have the date range default to the previous month? Thanks for any suggestions in advance

The access front end has all the queries, forms, reports and macros. Tables are linked to SQL backend. Would Indexing the foreign keys in the tables help with performance? Right now only the Primary keys are indexed.

I have an Access front end and SQL Server backend database that is about 3years running and now having problems with speed. The problem is intermediate. I am not an expert in SQL and dont know where to start, can someone help me troubleshoot this? Thanks in advance

Thanks i will take a look at your link :)

Thats good to know unmarkedhelicopter, not sure how to do that, not much of a programer but have done some, can you tell me how to get started? Thanks

I agree with you but for reasons that would take to long they want to do it in Excel, I didn't think you could but thought i would throw it out to the group to see if there was something i might have missed. Thanks

Is there a way to export data from an Excel spreedsheet into Access? I know how to import from Access but i need to do it from Excel. Thanks

Does anyone know what a sif file is and how it can be imported into an Access table

OK i looked at several posts and but i just can not get it to do what i need. This should be a simple thing (hum, how many times have i said that) I need to be able to automate an email with an attachment saved as a PDF after filling out a form in Access. I have tried the SendObject and the...

What if Access form could view the contents of a folder on the network? Then if it is a pdf file they could select the file and open it from within Access???? Anyone know if this is possible?

We will be storing them as images They want to store the images in the Access tables, however i think this will slow down the database so i would like to have a link stored in the tables. Is there a way to make this a one step process? Right now they scan the document in a folder on the...