Search results for query: *

I have an unusual request from someone. I have a main and subform. The last field in the subform record is the only piece of data needing change per subform record. It is the "Profit" field that is input. On the Main form topside, I have the usual "hands" navigation buttons for "next...

I have a form button on my frmJunction. The purpose is to run a crosstab Qry. The Qry runs fine but it is Minimized on the tray below. i think it has to do with my Forms all using "YES" for Popup and Modal. how can i get the results to be maximized?? Private Sub APPOINTMENTS_Click()...

the following sql is my crosstab query. TRANSFORM Count(QryJobDetail.CusLocID) AS CountOfCusLocID SELECT QryJobDetail.LocFullName, QryJobDetail.LotBlock, QryJobDetail.LocFullAddress FROM QryJobDetail WHERE (((QryJobDetail.JobStatus)="appt")) GROUP BY QryJobDetail.LocFullName...

I have a main form which has a button, noted below, that creates a new blank screen for Main form top section input. it works fine. Private Sub cmd_ADD_Junction_SHEET_Click() DoCmd.GoToRecord , , acNewRec End Sub But now, i want to ADD a button on the Tab page to create a new record in the...

I give up. I have a Qry with a Sum on that totals line for StdQryAct field. I wanted 2 decimals. instead, I get 9 decimals. The table is a number field, fixed 2. So i tried the following in order to use the Round function but i still get 9 decimals instead of the desired 2. I have the word...

I am getting #error on this Qry calculated field. The Cleanhours1 comes from Qry1 that seems to work fine. However, Qry1 which has these CleanHours1 may not have a matching record in Qry2. Qry2 is the primary join Qry where i want all Qry2 Sales records. In Qry3, i Join Qry1 and Qry2...

I am thinking that my calculated field is having trouble being a calculated number field. The underlying fields are all number fields. So why would the Qry answer be aligned left. I am worried that the calculated field converted itself to Text. Do you see something in this calc to make the...

Below is vba that a consultant wrote for me a few years ago for a text field doubleclick method. i now have a need to doubleclick that uses an autonumber field named JunctionID. Can you advise on proper statement for this autonumber deal? Below is my current working method when the field...

I have a Combo box where you select an item. I would like to have a message after i pick a choice: "You changed the Value; Do you want to change this? " something like that. Secondly, Will the person need to enter Y or N? Or is there another way? Below is my starter After Update...

Strange. I have a table with a field called RevHist$. It is a number field, single, 0 decimals. EG a record shows 4.95 revenue dollars. I place the field into a query. I run the Qry and it displays 4.94999980926514 why is this? i want to avoid using round etc, if possible. so as not to...

I am trying to make just 1 query instead of 2. I could make a second query sum up the values. But i am stubborn. The hangup is my Invoice date field. Maybe there is an SQL addition to allow me to have just 1 qry? I am taking many invoice records and summing up the Revenue$. I use a Date...

I don't know what happend. I have a Startup form. I have a few buttons on this form which bridge to separate forms. EG Reports Menu. For some reason, the Report form menu, and the rest, all go Minimized. I cannot get to them. how do i fix? this never happend to me before.

i have a table text field named OldProdhier. I want to have One Qry ask me a question. It is on the criteria line in the qry: [Enter Not Like Meat Cultures or Meat Cultures] There are only 2 answer situation. I want to type in ..... Not Like Meat Cultures to get the 1st answer. I want...

I have a Yes/no field on my form. The check box is extremely small. I size stays the same when I try dragging the edges. How can I make the checkbox larger?

I tried a technique noted somewhere in the site. On a form, I made my Pop Up and Modal to "YES". I then had a full Form screen. However, i have a few "double click" fields in my form. They stopped working. So I put Pop up amd Modal back to "No" and my double click fields worked again (when...

I need an extra statement to make this work. I have a table with 2 ranges of data. The qry needs 2 things to seek the proper records range. I only have 1 thing programmed so far. that's my problem. I presently have the Qry use PACKUNITS to look at the 2 ranges. you can see PackUnits in...

Is it possible to have a Qry field name display the name on 2 rows? Say the field is named Price Level 1. I would like to see: Price Level1 I presently get Price Level1. If this is possible when i run the qry, i wonder if the "2 row" field name can be copy pasted to Excel, Also as a "2 row"...

This is a 3 query deal. The first query collects the records based on a [start date] and [end date] of invoice date. The 2nd Qry works fine and displays the result. I then tried to make a Crosstab off of the 2nd Qry. However, i get "microsoft Jet engine does not recognize "[start date]" as a...

Your earlier LIKE info was perfect for me. This is a different question within the LIKE area. The Like question is [Enter Last 2 FormulaID digits or Enter for ALL] ..... etc etc. But what if i forget the Last 2 digits? So my new question is, can i have the grey screen which asks me for a...

I have a Qry that does not return ALL the records when I hit Enter. If I do not use the LIKE Criteria statement, my ALL results are perfect. So it is my LIKE statement. I have tried the "LIKE" below with no success: Like [Enter Last 2 FormulaID digits OR Enter for ALL:] & "*" Like "*" &...