Search results for query: *

Hi I have converted a word document to '.pdf' using Adobe Acrobat Proffessional v6. We would like to have the file expire after a timeframe and in effect making it unable to be opened. This would achieve quality control and prevent old information from being accessed. Any advice would be...

Hi I have converted a word document to '.pdf' using Adobe Acrobat Proffessional v6. We would like to have the file expire after a timeframe and in effect making it unable to be opened. This would achieve quality control and prevent old information from being accessed. Any advice would be...

Hi all Cant really find too much on this subject. I want to be able to open and view a pdf file of the users choice from a list box. The location of the files would most likely be on a network drive or cd. The specific file reference will be stored within a table. My question is how to...

I have created a query with multiple feilds and assigned wildcard criteria linked to my form to each feild. The following is an eg. LIKE "*" & [forms]![formname]![formfeild] & "*" this works fine when the query is run. I have created a form with the intention of the user...

Hi all, The keyword search is down for maintenance so here goes. I have created a query with multiple feilds and assigned wildcard criteria to each feild. The following is an eg. LIKE "*" & [forms]![formname]![formfeild] & "*" this works fine when the query is run. I have...

Hi, I am trying to create an sql with to criteria. 1. being the region and 2. between dates. strNotChartCount = "SELECT * FROM tblnotice WHERE Region = #" & strRegion & "# and IssuedDate BETWEEN #" & strStartDate & "# AND #" & strEndDate & "#" The syntax...

Hi all, Its been a while since my last visit. Here goes, I have created a report that uses a query that calls for data between a start and end date. I am trying to create an SQL using the start and end dates to retreive information from 1 month earlier. I thought that I could acheive this by...

hi, I have created a template document with a number of check boxes, combo boxes and text boxes from the form toolbar. Once the form is locked all controls work fine. The user can then type in text but they cant change the properties of the text eg. Bold, Italic and font size etc. They cant...

hi all, There maybe a simple solution I just cant see. I have a table lets say 'Invoices'. There is an 'invoice paid' date feild and an 'Passed' date feild to record the date the invoice was passed to a debt recovery service. I have an financial activity report that needs to show all invoices...

Hi all, I must be one of these people that try and do things the hard way all the time. This I hope will help others. I created a table with 2 fields(Region and Invoices Issued) specifically for the data to be used in the chart. Then used a query in the report_open() section to give me a sum of...

I have an unbound chart in a report and simply want to use data from text boxes instead of a query or table. I cant find any code to perform this function. Is it possible?

Hi all, I have a report that is not bound to a table or query. I have written all the queries in code to collect the data and fill the report as required. I want to place a chart into the report to snaz it up abit. I placed an unbound chart into the report and set up the properties to display...

Hi all, I have 1 table that has date fields to record different activities. I need 4 queries to pull data from the table to show the activity within a specified time frame. The question i have is how can I write the data pulled from all queries to 1 table to use on report. Cheers

Hi all, I have created a parameter query that asks for [start date] [End date]. Is it possible to capture each parameter for later use eg. Reports cheers

Hi all, I have a combo box that finds and opens the record withiin a table. The feilds contain a numeric ID a company name and a trading name. when the combo is opened the numericID is in order but i want the company name to be in alphabetical order. I have problems trying to use text as a field...

Hi all, I have a query written in code to count records within a table. The query needs to pull information on 4 criteria. I can get the query to work on 2 criteria but as soon as I try the third it fails. The code is as follows: Set rs.openrecordset("Select * from tblSummons where...

I have read some of the past threads and noticed that everyone is trying to resize forms to fit the screen resolution. I know this sounds basic but why not change the screen resolution on app startup. I dont have an idea where to start from but maybe someone can help me, because I have have...

Hi, I have to create a monthly report for the program I have written. I need to run a query through code to show information between specific dates. I have a field named "DatesIssued" in my table. I need to know the correct syntax for the query. I created a simple query using the query...

hi all, on startup i have a form that is not linked to a table. In the form_load sub I want to check 3 invoice tables for overdue invoices and show a message to alert the user. I have tried to access these tables using Dim db as database Dim rs as recordset Set db = Currentdb Set rs =...

Hi all, I am trying to access a table at run time through code to change the value of certain feilds. The form at run time is bound to table 'A', I have a listbox on the form that is populated from a query of Table 'B'. Once the user clicks an item in the listbox I want to change the value of a...