Search results for query: *

Hello, I have a query I am trying to get to work and can't quite work it out. I have a date field called visit_date. Everytime one of my users visits a customer he enters record and the date for the record is create =date() I would like to query for customers taht have not had a visit for the...

I have a macro that outputs a table to excel. The table has a field "objective" which is a memo field so it holds more than 255 characters. However after I have output the table to an excel file and open the excel file some ofthe data is missing from this filed in the workbook in fact the cell...

In MS Access there is a function OutPutTo which enables you to output a databse object such as a table or query as a file such as Excel, to a designated location c:\output.xls. Is this function available in Excel ? I would like to create a macro behind a button on a worksheet that will output...

Hello, I have two workbooks in excel. workbook one is blank and will be filled in by an end user. Workbook two is a data source of; column 1 column 2 manufacturer model sony vaio hp prosario What I am trying to do is - when an end users types Sony into...

I am trying to produce a label generated by crystal. I would like to either print four labels per page on a laser printer using acery labels or alternatively use continuous feed printer and produce one lable per page. Crytsal doesn't seem to come with many label options. Can you help ?

I have a report that has a small square box on it. I would like to use an if statement to fill the box (black) when a certain crieria is met Else don't fill and leave white. Does any body know the syntax ? IF {blank square??} STARTSWITH "NIGHT" THEN {fill black} ELSE "

I have a worksheet with four columns and 80,000 rows of data. When I distribute this file to my end users I would like them to be able to open the file and be presented with a search field that enables the to search for the data located in any of the columns by using part words and complete...

Hello, how can I count between two dates in a query. I have a [start date] field and a [date complete] field in my table. I would like to create a field in my query called [numdaystocomplete] to count the number days it took to complete a task. Can you help ?

For some reason today our users are being periodically locked out. Their doesn't seem to be a logical reason. I have been unlocking accounts all morning. The users do not seem to be in breach of any policy although we do not have any group policies defined. The windows 2000 network is 12 months...

Has anyone had any issues when configuring offline files? I have two lap tops same make and model same OS. I have configured them the same to use offline files. One works fantastically and the other just wont synchronize. After selecting "make available off line" the computer appears to start to...

hello, I have a some address fields on a form. One of which is called website. This text field \ text box hold the web address. I have formatted the object properties to is hyperlink. This formats the appearence of the text to a hyperlink however the hyperlink doesn't work as a hyperlink. Any...

I have recently configured a Windows 2000 DC and put it on the same IP network as a netware domain. I have configured one PC to access the 2000 network exclusively. The remaining 8 clients all log onto the NetWare server. I want the remaining clients to be able to log onto to both. Is this...

My first question is how do you say or in an IIF statement. If you want the statement to return from two fields with different data. For example Month year date part decemeber 2003 2003 january 2004 2004 I would like my statement to return both...

Is their a date format month-year i.e November 2003 ?The closest I can get is 07 Novemeber 2003.

I am trying to perform a delete query using two tables however I only want the data from one table deleteing. The query is based on the "find unmatched query". If data exists in one table and does not match data in its linked table then i want to delete it. However when I run the...

Has anybody ever developed access as a calendar tool. i.e with similar functionality as an MS Outlook calendar but less advanced ?

I have a field on my report called revision. This returns the revision number for a product. If I have two revisions of a product I get two products on my report. I would like only the product with the latest revision to be displayed. I.E the highest number.

I have some calculated text boxes on my report that I would like to use in other calculations but when I run the report I am prompted to enter the vaues in a parameter dialog box. How can I over come this. Example TextA + TextB = TextC =Sum([TextC]) I am unable to use TextC

I have created my forms on a PC using a screen resolution of 1024x768. I know need to convert my forms to accomodate a screen resolution of 800x600. Is their a quick way of doing this ?

I am trying to perform a calculation on my form which takes into account todays date. I would like a filed to be be text box to be calculated if todays date is the same year as the date the form is filled in. If not then I would like to return a zer0. Example TextboxA = 2003 text field...