Search results

Hi, I have two master tables set up. Right now in both tables, I have the PK set on a particular field(so the PKs are not the AutoNumber) If I manually change the PK to be the AutoNumber for each of the two tables, is there any way to prevent adding the same records twice in each table...

Hi, There are 3 subforms on my mainform in where users do updates. All the subforms are referenced by the Pk on the main form. There is another unbound textbox on the main form that simply reminds users the PK they last updated on the main form, and it works great. The code is...

I think I solved the problem. Somehow it just takes longer for it to get reflected on the front-end. It was a field that I added in the back-end. After I waited for a bit, it started to show data. Still strange though. Shouldn't it be instant?

Hi, I'm pulling my hair out on this one. (handling null values in a parameter query) I've attached a copy of my test database. The problem is...as you can see in the query... if I leave the field blank, nothing gets returned. However, it works if you actually specify the criteria. I must be...

Hi, Ｉ　ａｍ　ｔｅｓｔｉｎｇ　ｏｕｔ　ｔｈｉｓ　ｍｅｔｈｏｄ，　ｗｈｉｃｈ　ｉｓ　ｆｏｒｍ－ｂａｓｅｄ　ｐａｒａｍｅｔｅｒ　ｑｕｅｒｙ．　Ｉ have attached a copy. Ｔｈｅｒｅ　ａｒｅ　ｏｎｌｙ　ｔｗｏ　ｆｉｅｌｄｓ　ｏｆ　ｉｎｔｅｒｅｓｔ．　Ｉ＇ｍ　ｓｔｉｌｌ　ｓｔｒｕｇｇｌｉｎｇ　ｗｉｔｈ　ｔｈｅ　＂ｉｓ　Ｎｕｌｌ＂　ｉｎ　ｔｈｅ　ＯＲ field. I think that's where the problem is, but I'm not sure how to go about fixing it... Right now, if...

Hi, Currently, I have a report that's formatted as follows: Facility #: Serial # L1030 90345 35232 234232 L3534 90345 34523 23423 Is it possible to get Access to...

Hi, thanks for the reply. So on my record table, I actually only have two columns. The values in the 1st column are PK from table A, and the values in the 2nd column are PK from table B. If I want to have a duplication check against only the 1st column(it's okay to have repeating values in...

Hi, I have a form based off of a query. When I add this new control(bound) from the query, I keep getting #NAME even though I have checked that the column is there in the query. I must be missing something here... can anyone help me? Thank you

Hi, I'm creating a form through which users pass parameters into a query to generate a report. So on the form, there is "generate report" button. There are only two fields of interest. On the search form, I have two unbound textboxes, which I turn into combo boxes, and these two combo...

Hi, I have a record junction table set up and I populate this junction table by having two other tables to feed into it. My question is.....is there any way to put a duplication check in a column within this record table? Users do not want to add the same facility twice into the record. Can...

Below is the query in SQL view: (The WHERE part) WHERE (((Record.Type_of_Change) Like "*" & [Forms]![Date Search Form]![Type] & "*") AND (([Master Fee].Effective_Date) Between [Forms]![Date Search Form]![From:] And [Forms]![Date Search Form]![To:])) OR ((([Forms]![Date Search Form]![Type]) Is...

This is the code behind the refresh button on the search form. Private Sub Refresh_Click() Me.Text0 = "" Me.Text2 = "" End Sub where text0 is the 1st date field and text2 is the 2nd date field. -------------------------------------------- This is the code behind the report. Private Sub...

Hi, I have built a form-based search. On the form, users specify effective dates. Two buttons, "Report" and "Refresh", which refreshes the form only. What's bothering users is that...every time they put in a new date and generate report, they have to hit the "Refresh All" button at the top...

Hi, I have three unbound textboxes in total on this search form. The first two are date fields and they all work well if you leave them empty. The problem is....if you leave the first two date fields empty and pick a value from the 3rd one(it's a combo box), query returns ALL records...

Hi, I would like to run a query that shows a record having the highest value in one of its column. It's a numeric value. Wonder what should the syntax be in the query. any thought is much appreciated.

Hi, I have an working union query from which a report can be generated. The union query combines two queries, which represent two tables. One of the features I would like to add for the users is the ability to specify the city name when the report loads. Right now when the report opens, it...

Hi, I am having some trouble with this query. Users track issues by due_date. So for example, user wants to find out how many issues are due in 10 days, or in 14 day, etc, depending on the number of days they specify. As you can see in the test database, I have a field set up that...

Thank you very much Bob. It works like a charm

Hi, I'm not sure if I've fallen into the trap of table level look up for this one, but I'm simply trying out a combo box filter that can be useful when it comes to data entry. I have attached a copy. Users will typically select a category, and depending on which category they select, the...

Hi, Has anybody ran into this problem before? I have the report screen open. If I just want to quit the application from this stage(Access 2007) without closing tabs at the top, Access will give me an error: "Command or Action 'SaveRecord' isn't available now. Run-time error '2046'...