Search results for query: *

Hey there! I found another thread 701-797928 that talks about parsing data and how to get the information before a character, and a seperate one for how to get the data after a certain character, but would I would like to do is do both from the same field. I have a field in a table where there...

Hi there, I have a problem where I have a combo box set up on a form which I use as a search field to bring up various invoice numbers. My problem is that in the search field, there are at times duplicate invoice numbers, but the invoice numbers have different information against them. Both...

Hello there. I have a form for entering invoice information, and I have 2 different currency fields. Field 1 is for AU currency, and the other field is for foreign currency. If a foreign currency amount is entered, then the user is supposed to select a drop down menu in another field which...

Hi there, I want to make a field in a database a unique field, so no one can enter a duplicate value. The unique field will be for an invoice number. In some instances however, when the record is created we do not have the invoice number yet, so we need to come back to that record at a later...

Hi there, I hope someone can help. I need to create an event procedure on timer that will automatically take a query, and save it in excel format to a folder on our system. It should save over the exisiting excel document each time it runs. The query name is Intro_Total_Daily_qry. I know how to...

Hello. I have a form with a subform in it, that displays a record set in datasheet view, which comes from a query. In the record set it shows 3 different types of letters sent to customers. The letter field is a yes/no field. What I would like to do is create 3 buttons on the main form that...

Hi there, I have a form set-up on my website so that when someone enters their information it redirects to another page saying thank you. What I would really like to do is have a new window pop up, leaving the old window open. I know how to do this in a normal link easily enough, but not in the...

Hello, I have a whole lot of name and address data in a table that gets imported from an excel spreadsheet. My problem is that there are many duplicate address records in the "add1" field. This field shows the street number and name. This happens because there are often people at the...

Hi there, Can anyone help me please? I want to turn a field in my query from seconds into hours:minutes. So another words 8019 would now be 2:13

I have a query that is counting yes/no fields. There are 3 fields titled InCall, Arrangement, Resolution. I have a 4th column that calculates the sum of these 3 fields. The only problem is that when one of the fields is blank, the 4th column won't return a value at all, even though the...

Hi there, Is it possible to set up a table so that no one can enter duplicate data for an entire row? Example of what I mean Stats_tbl id field Username field Date field other field The 4 fields above will often have some of the same data appearing in them. Another words username field will...

Hi there, I have been having a problem quite a lot lately when I import a form from one database to another, it seems to corrupt all of my forms in the database I am importing the forms into. I am using MS Access 2000 on Windows NT and I am on a network. At first I had thought it was only when...

Hi there, I currently have a button set up in a form in access to automatically print out a report. The only problem is that I need to have the report print to tray 2, where as the default on the printer is tray 1. The reason for this is that it needs to be printed on coloured paper rather than...

Is there a macro, or some code that will automatically set up the printers settings? I currently have a button that automatically prints out a report. The only thing is that when this was printed manually, tray 2 was being selected on the printer in the settings. Is it possible to configure it...

Does anyone know how I can boot people out of Access? I believe there is a program that does it? My database is on a network. I also have a related issue where people are out of my database, and have been for a few days but the .ldb file is still there, and still shows 2 people in there that I...

Can anyone please tell me how I can get the Win 2k user name to show up automatically in a field in a form? (or even more ideally if this could work directly from the table) The database has not had securities set up on it, so no one logs into the database. The table name is DDChange, and the...

I am sending a report from Access to an .rtf document. I lose formatting when I do this. Does anyone know if, and how I can have a preformatted document in this format? (or alternatively in .htm format) I originally had it in .snp format but most people do not have this installed on their...

I would like to have an option in my database so that when I tick a tick box, it is stamping a date/time against that field. The reason I need this is for is when someone enters data into a form, it has a date against that data set. When the information is updated I would like the new date time...

On a regular report I use I need to adjust the print margins from the standard settings to "Landscape" and left and right margins to 0.99. The only problem is that when I close the report and go back into it at a later time the settings I put in previously are gone, so I need to...

If anyone could help me I would really appreciate it! :-) I have set up a table that has "yes/no" fields in it. The yes fields which I need to calculate from come up as -1. So in both a query and a report when I total the figures from that column I get a minus figure. E.g. 5 ticks in...