Search results

Thank you TessB, Thank you, I am going to try that right now. It makes complete sense to me. I will let you know if I have problems, but I don't anticipate any as this is a great idea and should work ... Thank you very much, Joe :D

Hi Folks, I would like to (have to) automate a way to collect some survery data for a non-profit governmental agency into a database... the problem is that, each one of the surveys that come in from the agencies are 24 pages in length and therefore add up to several hundred fields on forms in...

Hi Folks, I am wondering if this is possible with a simple criteria in a query, and if so; any help on how to stucture that criteria would be greatly appreciated. Briefly, this is for a non-profit governmental organization. I have two tables: The first table contains a unique identifier, a...

Thanks dcx, I just looked at the data again, and found records with 'NON' back-to-back also. So what I would have to do, I think, would be to somehow use a query or code to: I have already created a table that display a row count for the number of lines by identifier - 1 because the very...

Hi Folks, I am trying to find out how many times a person switched from Medicaid to Non-Medicaid Status and visa-versa for a non-profit government agency. I have filtered the data to show three fields: Client_Indentifier, Effective_Date, and Medicaid_Status (either flagged as MCD or NON)...

Hi Folks, Does anyone know what is includded in the Developer's version of Access that is not includded in the regular version? Also, does access have some sort of royalty free version of the program that people can use for free to use access databases but would not be allowed to create/edit...

Hi Folks, Is it possible to log a sender's address, receipent's address, message subject, body of message, and name of attachment if one exists into Access? I know very little about integrating such functionality with Access, and any help or information would be greatly appreciated. The...

Hi Folks, I am finalizing a program I have written by creating some error controls/warning messages. The code below doesn't want to work ... I think I am doing something stupid, but can't seem to find out how to get it to work. I have used the exact same code without the DoCmd.RunSQL and...

Hi Folks, I am trying to utilize the DoCmd.Rename feature in a module to rename an external file; however, no appropriate Object Type is listed for the DoCmd.Rename function to rename files? Is there any function where I would be able to rename an actual file? Thank you, Joe

Hi Folks, I am not sure what I am doing wrong here. I have this code that works perfectly to import a file: Private Sub Command0_Click() DoCmd.TransferText acImportDelim, "270 Import Specification", "Temp", "C:\test270.txt" End Sub As soon as I try to add a few lines of codes pasted below...

Hey Folks, Is there any simple way to add a file menu to a form ... sorta like the 'My Computer' screen that shows all the letters of the drives on the computer/networked drives, etc or similar to the Corel WordPerfect or Microsoft Word file/save as screen listing all the drives on the computer...

Hi Folks, I have a table with about 20 fields in it, about a dozen of the fields are set as either 'Yes' or 'No'. I would like to somehow count the number of 'Yes' values in each one of the fields automatically. I have tried the count function, and all it does is show me the total number of...

Hi Folks, I have two databases. One database shows a unique identifier per person and a unique date for that person -- the unique identifier (person) can have more than one unique date. The other database shows a unique identifier per person and a unique date for that person -- the unique...

Thank you -- How do I specify the fieldname Thanks Travis. I tried the code, and it gave me an run-time error #13, but I think it is easy to fix. I think I am getting the error because it appears that I do not know the syntax to use to tell the code which field to look at in the query (or...

Hi Folks, I have created a query named UniqueNPROV which lists all unique values for the NPROV field from the Claims table. I am trying to write some code, so that once a command button is clicked, a unique table is created from each one of the unique NPROV values and the table has the same...

Hi Folks, I have several fields in a table, each field in the table can be either a Yes, No, or Null. Is it possible to run a query that would display how many Yes answers exists in each field (group the Yes count by field). Is this possible, or do I have to create a TOTALS query for each and...

Hi Folks, I have this code snippet that is suppossed to take a criteria passed from a text box on a form and insert the value into an already created table's field. For some reason, it isn't working. Any help would be greatly appreciated, the code snipet is pasted below. I should mention...

I figured out how to do it. Everything work great. I would like to add one more option, but I have no idea if this is possible and I don't know VBA very well ... the users of the database may not remember ALL the table names they specify for archieved audits. Therefore, would it be possible...

It is a database for a non-profit government agency to perform aduit control (make sure no one is abusing the system). The database is pretty complicated, but I was thinking that each time someone goes on an audit, they can use the database to create a template/input form that they can use to...

Hi Folks, Is it possible for me to create a command button, that when clicked, would ask a user what name s/he wanted to give a table and then to make an exact copy of the already existing table to the table name the user specifies? Further more, is it possible to create another command...