Search results for query: *

I have an ACT 6.0 database. I am trying to create an Access front end to the data. I am linking to the tables via a Dbase IV ODBC connection. However, the fields I am getting in Access are not consistent with some of the fields in Act. I am not getting some key contact fields such as email...

I have an ACT 6.0 database that I am attempting to link to Access as a linked table. The link is working fairly well with the exception that my field names do not match what is in ACT. I also noticed that some of the fields that appear to be on the contact record in ACT are not showing up in...

I am attempting to link to my ACT database from Access. I am doing this through the link table function of Access and establishing the link as a link to a DBIV database. Overall this is working well. However, I cannot get the email address field. It is in ACT and all of the other fields...

What I have is a MS Word Document that is a form. I have protected the form, allowing entry into text fields only. My problem is that I need to paste a signature into the form after it is protected (signature could vary based on who is doing the inspection). Problem is I cannot paste bmp file...

Yes, I am able to delete the records from the table manually. It is on my local hard drive, so I am not sure why I can't delete.

MoLaker, Here is the query. DELETE [Current Period Reporting Table].* FROM [Current Period Reporting Table] INNER JOIN [Deletion Table] ON ([Current Period Reporting Table].[Pharmacy Number]=[Deletion Table].[Stla Paid Claims_Pharmacy Number]) AND ([Current Period Reporting Table].[Date...

I am trying running a select query to tell me which records need to be deleted from a table based on a certain set of criteria. Once this is done, I have converted the select query to a delete query since I just want to run the same query in a delete mode. However, when I run the query, I...

Thanks to all who responded. I was finally able to get this to work. For some reason, the way I had to reference the field was report!txtcount in the controlsource.

Lupins46, Thank you for your response. It looks like this is going to work if I can figure out one issue. When I set the textbox name in the footer to =txtknt, the report is not recognizing the reference.

I have a report which lists orders. The orders are listed at the line item order. Therefore, there may be multiple line item records for a single order, all carrying the same order number. What I want to do is display the count of orders on the report. I have a query that does this, but have...