Search results

If each table has 4 records that have the same Cust_id, Payer and Therapy (Structured Day) - and the tables are linked on Cust_Id, Payer and Therapy then I would expect 4 records to be returned.

Hi Doc_Man, I just included every other field available and still got 8 records. Also, I can't join Original_UnitsBilled to the other table because it doesn't exist there. I've never seen this happen before when the joins are correct. Is this a bug in Access? Thanks, TS

Okay, I admit I've had a long day and that my eyes and brain need a break. But - If Table1 has 2 entries each for Cust_Id (600145 & 600136), Payer (MLTSS) and Therapy (Structured Day) : {Total entries = 4} and If Table 2 has 2 entries each for Cust_Id (600145 & 600136), Payer (MLTSS) and...

See attached example. I would like to have a form that has three command buttons positioned next to each other (side by side) in the uppermost part of my form. They should always be visible. If the first command button is clicked I would like to have another specific form open in the lower part...

Figured it out. The sort has to come before the group. Thanks for your help!

Thanks for your reply pbaldy. The sorting is set up in the Group & Sort from the report's design view. It is also sorted in the query recordsource. So, I have both bases covered. I should mention that the sort issue is contained in a subreport. When I click on the subreport within the main...

I have a report which has a query as its recordsource. The query sorts the "Task_No" field in ascending order. The query works fine but when the report opens the "Task_No" field is not always sorted properly. Sometimes it is and sometimes it isn't. This just started happening after we migrated...

Nevermind. I just replaced "If IsNull(rs2("Number_UnitsBilled")) = True Then" with "If rs2.recordcount = 0 then" Now all is good. Dumb mistake. @Josef P - Thanks for responding.

The code below returns a null string (as it should) in query design. However, in my VBA code the vartype for rs("Number_UnitsBilled") is 9 which indicates that it is returning an object. Therefore, the program crashes with a "No current Record" error in the "Else" statement. How can this be...

Thank you all. Very useful information! I solved my problem after I noticed a syntax error involving parentheses.

I am trying to use a msgbox to debug a query I have written in VBA code. However, the msgbox is not large enough to display the whole query. Is there any way to expand the msgbox so that I can see the whole query? sql1 = "SELECT tbl_Authorizations.ID, [tbl_Authorizations].[client_LName] & ', '...

Place a configuration file somewhere on the C drive (It doesn't need to have any contents) of all paying customers during installation. Then check to see if it exists. If not then Quit the app. Dim IsItThere As Boolean '*** Security Check in Login Form. IsItThere =...

cheekybuddha - The first one worked. Thank you so much!!

The stored procedure exists in my SqlServer database. I'm not sure what you mean by "mssql". Where do you see sp_AddUser?

arnelgp - I used your code as a guide for my code below. I'm getting an "ODBC - Call Failed" error. Can you see anything wrong? tbl_Time is a linked table to my Sqlserver database. Do I need a special library? Public Sub Create_SqlUser(NewUser As String) Dim db As DAO.Database Set db =...

Thanks so much. That definitely isn't intuitive!

Any suggestion as to how to keep the image in the background? When I place my controls on top of it they end up behind the image.

Yes. I'm trying that now. It seems to have worked. Thanks so much!

Thanks for your response MajP. I shrunk the form from 13 to 10 inches. Same problem. Anchoring won't work because there's no option for keeping the controls in the center.

The controls in frm_Dashboard (see attached DB) are exactly where I want them in Design view. However, when I switch to Form view all of them shift to another location. I've already played around with all the properties and can't seem to figure out why this is happening. Does anyone know?