Search results for query: *

I am having a problem getting my Query to use the SubForm value as search criteria. I have: Access version 2003 Mainform - Location Master Browse - Location Number Subform - Location Account Browse SubForm - LocMast - Location Number Query - Bank Master Browse Query - LocMast - Location Number...

I am using CR 10 and have grouped by data hierarchically to produce a Table Of Contents. The TOC is perfect as far as the data being correct but I need to format the various levels of the TOC different based on what level it is. My question is how do I determine what level I am at so I can...

I have a JPG file that I am try to put into a Excel cell. I am having no luck with this. Anyone ever done this before? It sounds easy enough but doesn't work for me. This is the code I am using. toSheet.Range("C28").Value = TempSig.JPG Any help would be greatly appreciated.

I am trying to develop a excel spreadsheet that mirrors a set of reports. In a couple of the reports a JPG file stored in a General field in printed on the report. I need to know the method to allow me to copy the JPG file to a cell in the excel spreadsheet.

I have a application that needs to both print foxpro reports and populate a pre-formatted excel spreadsheet that mirrors the reports. This is working great by using a scan loop and writing to each cell per row for each record. My problem is that for a certain excel worksheet, I have many more...

I have a report with 6 databases. Three are of the 1 record type and as only used for addressing purposes. They have no related fields. I added a field to each table called RptLink and put a value of 1 in it. In my record selection statement I say for each table that RptLink = 1. I am not...

I need to create new records for a table that is linked to my input table but is not on the form. What is the best method to do this? Do I use a query or VBA code? I am using Acces 2002. Any examples to help explain would be appreciated. Thanks

I have a very confusing problem. I will try to explain it as clearly as possible. I have a WAD Master (Work Authorization Document) table which tracks the duration and cost of a project. The projects can have up to four phases and by contract there are a certain number of days allowed for...

I have setup Access group and user security with the security wizard but the application opens up without asking for a login or password. Any ideas?

I have used the Security Wizard to set-up Group and User accounts and it seems to work just fine as far as restricting users from places they don't have rights to. My problem is how to create meaningful error messages instead of the "Command not exectued" cryptic message that Access...

This seems like a very simple problem but it is driving me crazy. I have a form with two combo boxes, the 1st one (Location) uses a value list and the 2nd one (Building) uses a query. What I am trying to do is let the user pick a location from the first combo and using that value filter the...

I am really a FoxPro developer instead of Access and I have done this many times before in FoxPro but can't figure out the code required in Access. What I need to do is loop thru Tbl1 updating certain fields based on other fields content, then while still on the same Tbl1 record lookup a Tbl2...

I have a laptop that is loaded with only one app. It is booted up into this app when powered on and it is supposed to power down when exiting. This process worked correctly in Win 98 but doesn't under Win XP. The boot part works correctly but the exiting and power down doesn't. Anyone got...

I have created several reports in Crystal Reports 8.5 using Acess 2000 databases. The reports work great but now I need to put them in my Access system for the users to run. I am new to Access and have started messing around with the switchboard. What is the best way to call the reports from...

I have created several reports in Crystal Reports 8.5 using Acess 2000 databases. The reports work great but now I need to put them in my Access system for the users to run. I am new to Access and have started messing around with the switchboard. What is the best way to call the reports from...