Search results

I have a form with a table behind it, i would like to have a button so that when a user clicks on it a smaller form pops up and any information that is entered is saved in the record on the previous screen/form. Both forms would have the same record source. Is that possible and how can it be...

I have a form that asks people to enter in certain information. What I would like to have happen is when the user clicks on a button some of the information in that form is emailed to an email address. Is that possible? If anybody can help me, I would be extremely grateful. Cheers, Mike

I have two tables with the exact same configuration, I need to create a query that joins the two of them together. When I have attempted to do this so far I get an error saying that it could not complete the SQL statement because of ambiguous outer joins. Can anybody help me?

I have a report which is based on a table which doesn't have a primary key by design. One of the key fields in the table is one called Claims ID, there could be several records with the same Claims ID. I need a report that keeps all of the records with the same ID on one page however I am having...

Never Mind, I checked the Print Data only checkbox.

For some odd reason all of the labels in my reports are invisible. Can anybody help me out? Cheers, Mike

I have a form which allows me to add information into a table, however I need to verify specific piece of information against information from another table. For example: I have a field named Claims ID, when I enter the Claims ID number I want to be able to press a button called Verify and I...

I have a continuous form whose data comes from a query, and I have a combo box with values that I entered myself in the Form header. What I want to do is when I select a value in the combo box, the corresponding detail information changes. For example my combo box is called claim status, it...

Hi, in my table I have my primary key which is a number and they range anywhere from 1 - 1000 for ex one record's primary key may be 12, and another record's primary key may be 1023. What I need to do is to convert all of the numbers for my primary key in my table to 6 digits, ie 12 becomes...

Yes it is the last group of digits. I would say that the number could possibly reach in the 1000's but not any higher.

On the form there is a textbox which the Claims ID will be displayed in, what I need if for when the form loads the Claims ID should automatically show up in the textbox. When a new record is created I need the textbox to show a new Claims ID number which follows the next number sequence. i.e...

I have a difficult task to complete. What I need to do is on my form I have a field called Claims ID which is the primary key in the table that is associated with the form. The Claims ID looks like the following: 65-A-2002-01 What I need to do is have the textbox automatically display the next...

Thank you That worked...... thank you so much!!!!

I am having a problem with a function that I want to use with a textbox. What I want to have happen is when the form loads, inside the textbox I want information to appear. I want the text inside to be information from another form + T + the date, this is the code I wrote...

One more question... Thank you very much, I just have one more question. The report that I am working on has a field whose value will either be "Open" or "Closed". Do you know how I can use the count function to count the number of reports in the report with the fields value being "Open" and...

I need to count the number of records that are on my report. I cannot use the count function in the query that provides the report with its information. Can anybody help me?

I need to know how to change the text formatting on a report. What I want to do is, when a field for instance one called Status equals Open, all of the information that relates to that date goes bold. Can anybody help me?

I have a question relating to two drop down boxes in one of my forms. What I want to do is when the first drop box value is selected, the second drop down box will adjust/get new values relating to the first drop down box choice I have made. Does anybody know how to do that?

I am working on a school project and I have run into some trouble with a query. I need to find out how many days are in between 2 dates ie. Sept 1, 2001 and Sept 3 is 3 days. I am having trouble getting a numerical value. Can anybody help me?

I just ran into some problems with a form that is used for searches. It is a continuous form with the top portion used the search field and the bottom portion of the form is used to list all of the fields and data. When I search now I get this error message: Function is not available in...