Search results for query: *

I would to like have a .jpg picture and an audio clip to run when an .exe file is executed. Can someone assist with the code to perform this function?

As a power user of Microsoft and other products, I would like assistance in recommending a starting point to learn Visual Basic. For example: 1. What is the difference between 6.0 and .NET? 2. As a non-programmer, how would you suggest I begin learning visual basic and what version? 3. Is...

thanks LB

I'm trying to perform a calculation for specific criteria within a defined group of data. Example: Field1 is the data for gouping. If 78480 and 78478 in Field2 has the same value in Field1, then enter "Bundled" in Field3 on the same record line as 78480 from Field2. If 78480 and 78478 in...

I respectfully disagree. This is a Microsoft Access Query Forum and should be utilized to focus on the software's functionality. PHV, I appreciate that your were able to get the results I requested but this solution is not feasible if I were to build many scenarios for grouping calculations...

Error message received when modified the table as suggested. Microsoft Access can't represent the join expression A.CPT_INT = B.CPT_INT2 in Design View. Code used: SELECT A.CONTRACT, A.CLAIM, A.CPT, IIf(A.CPT="78480",IIf(IsNull(B.CARRIER),"Separate","Bundled"),"") AS Code, Int([A!CPT]) AS...

I really appreciate your help. I pasted your statement again and did get the correct results as you are showing. I must have missed something last time. However, I can't access Design View. I get the same error message above. I'm using Microsoft Access 2000 (9.0.6926 SP-3)I will need to...

yes, i did. Same as your sql statement.

Error message received: Microsoft Access can't represent the join expression INT(Book1.CPT)=(Book1_1.CPT)+2 in Design View. It would be benifitial if the solution provided will allow me to utilize Microsoft Access functionality instead of manipulating code. I will use the solution to this...

I’ve attempted to incorporate the IF statement provided. The results are close but not exactly what I’m looking for. For Carrier 1582 and 1583, I was expecting to see “Separate” as the Code in place of the “Bundled” code since CPT 78478 is not grouped with CPT 78480. Thanks for your...

All fields are within 1 table. Joins are not included.

The case is resolved. The query was producing Null values for a calculated field. The calculated field was referencing another field with text and numeric values; therefore producing Null for those that were text references.

Example correction: Example: Field1 is the data for gouping. If 78480 and 78478 in Field2 has the same value in Field1, then enter "Bundled" in Field3 on the same record line as 78480 in Field2. If 78480 and 78478 in Field2 does not have the same value in Field1, then enter "Separate" in...

I've tested a smaller group and have isolated the problem.

I'm trying to perform a calculation for specific criteria within a define group of data. Example: Field1 is the data for gouping. If 78480 and 78478 in Field2 has the same value in Field1, then enter "Bundled" in Field3 on the same record line as 78480 in Field2. If 78480 and 78478 in Field2...

Error "Microsoft Access can't add all the records in the update or append query. I set 622 field(s) to Null due to a type conversion failure. A type conversion failure is caused when the data in one or more fields doesn't match the DataType or FieldSize property in the destination table. For...

Thank you Golom. This worked.

I'd like to convert a number to a date format and be able to calculate formulas from the converted date field. Currently, if I try to subtract year 2005 from 2004 in the example format below, I don't get a true number of days. Example: 20050301 Convert to 03/01/05 Thanks, Craig

Still needing a resolution. Please assist. Thanks, Craig

It is possible that because the ME and XP Pro computer are part of the same broadband network is the reason that it works. The XP Home pc is not on the same network as the XP Pro computer. However, in the past I have been able to connect to the XP Pro computer from an XP Home computer but was...