Search results

Using the attached image, I want to either update all of the field names on the right table to those on the left or append the records from the table on the right to the table on the left. The fields from both tables are in the same order, but have different names. What can I do? Thanks.

In the attached image I have two graphs that are based on pivot tables from the same dataset, use the exact same pivot fields, and also are based on the exact same custom chart template. In one graph, if the series for the horizontal line is all zeroes, the line will not appear - this is what i...

Is there a built-in property to check if the value in a combobox is in the RowSource or not? I want to show a label on my form if the value entered in the combobox isn't in the "list".

Wow, what a horrible title.. I have this cross reference table that says: For (text) codes 10021-69900 Use multiplier .15 70010-79999 use .20 0001M-0004M use .50 I want to write a query that can then reference the text codes and apply the correct multiplier. I'd like to do this without...

Who is going to win it all? How far will your team go? I think it's Germany's year. Spain's style has been taken down by German teams a lot this year. Although I think it was two Spanish teams in the Champion's League Final?

Any 'vapers' in here? It's becoming extremely popular in america and I know a lot of people who have quit smoking because of these devices.

I have a pop up form that likes to change it's height after I enter design view among other things. I've searched the webs, but can't find out strictly how to set my pop up form to be height X and ALWAYS be height X no matter what. Albert's reply here was the best answer I've found so far...

I've found some code that will let me have a textbox grow on Mouse Over. The idea being that I want to keep the textbox small unless a user mouses over it, and they can then see all of the textbox contents. I've got code that will change it back to it's normal size after leaving the textbox as...

Does anyone know where to find a free access db that stores information on vehicles from general info to maintenance? I'm in the process of making one for myself, but wouldn't mind seeing what others have done. :) Edit: this will be used at home to manage a few vehicles

How can I remove the white space that follows the last record in my datasheet forms? Please refer to attached image. This happens in two different forms, scrolling in two different directions.

I have two unbound unlinked subforms residing on a 3rd unbound main form. When I enter the current record on Subform1 I would like the matching record(s) on Subform2 to be highlighted or otherwise formatted. I can get this to work for only the first record on subform2 due to the way I have...

After I enter data into one field in a record I would like the form to save the record when I move to another field in the same record. It seems that the record is only saved when I exit it entirely. Is there a way to save a record when moving between fields in that record? Can this be done...

I have a form that displays multiple records in datasheet view. I want to query off of that form and return all results for all records being displayed. However, I'm not sure how to tell Access to do this. Access instead wants to return records for only the first displayed record in the form...

I have two unbound subforms on an unbound "display form". I managed to link the two subforms by following this method: http://www.dbforums.com/microsoft-access/979668-link-2-subforms.html. This is great and works well enough, however, by design, subform2 will only display records relevant to...

How can I obtain the value of a record from my subform in datasheet view? Ideally I could double click in the "cell", for lack of a better word, and grab that value to pass through to another function. On double click event? What then? Edit: I suppose the user could select the row that...

As i'm designing this database I'm realizing there are several different ways to filter data on a form or subform, but I'm wondering if there is some reason why one or the other might be preferred. My use case: I need to create a form and/or form subform combo where the data is shown in...

I've spent far too long searching for the answer to this. On my form's onCurrent event I want to check if I am on the last record and if so, disallow navigating to the next "record" which is blank. I'm not sure why Access will let this happen to begin with when selecting Next Record. Isn't...

I have a checkbox that determines whether or not to display certain form controls. How can I also hide the resulting white space that comes from hiding the form controls? Can I put all of the controls in some sort of container and hide the container? The form objects are all displayed in...

I'm not sure why I'm having such trouble here. Last 7 days this year is no problem, but now I need those same days for last year; the caveat being that they must be the same Days of the Week, so they are comparable. If Yesterday = Wednesday of Week 38, then for Last Year I will need...

I just need to access my user-defined functions in all new or old .accdb databases. In Excel you can save them as an add-in or possibly to your personal workbook, but how can I do this in Access?