Search results

Thank you for the help, Paul. The link I posted is to help raise money for a 28 year old man who has had ALS for 5 years and is dealing with staggering medical bills.... don't even know what you are referring to when you mention a "SEO". I'll remove the link .........thanks again for your help.

Paul: IMO, I am really not a developer. I've written an access program for my business but I don't know 95% of the "tricks" that a developer would. I don't know the first thing about "variables"....is there a link you could send me that I could use to start some research on "variables"? Thank...

Thank you for your reply, Paul. The personnel that use my program aren't computer savy enough to do what you have described above. I was hoping to modify the Visual Basic Code as shown in attached (dup-record-code.jpg) to enable only a few of the fields to be duplicated into a new record...

I created a button in a form that duplicates the record so our employees can fill in the form more quickly. I know I am being greedy, but is there someway to change the VBC so I only duplicate certain fields in a record, not all of them? I have attached a (.jpg) of the Duplicate record...

I exported two new forms I created to 2nd database and for some reason ALL the forms I had in the 2nd database were deleted!!! I don't understand why this happened because I have done this before and the forms in my 2nd database were never deleted. any idea why this might happen? How can I get...

I am trying to import all characters in this field as text whether it is, 65611 or 65611A. However, Access won't let me import the 65611A fields..... :(

I am trying to import an Excel spreadsheet into an Access 2007 database. Each time I import, Access creates a 'type conversion failure' error database. I set up the first field in my .db to be a TEXT field because the Field will have both numeric and text characters. The field name is [estimate...

Sorry....I guess the internet works too fast sometimes! I was reading one of your replies when the others came thru I guess! lol Thanks very much for your help!

I will expand on the issue....I one table in a database where the telephone numbers are in two separate fields, i.e. [123] (which is the areacode) and [456-7899]. I want take the two fields in this table and combine these two numbers into one field so the new field will be in this format...

My reason for doing this is that another table has telephone numbers in the [123-456-7899] format that I want to import into the first table.

I have a table in a database where the telephone numbers are in two separate fields, i.e. [123] (which is the areacode) and [456-7899]. Is there a way to take the two fields in this table and put combine these two numbers into one field so the new field will be in this format...

Now I understand! Thank you for your help....Mark :)

It's not an executable file, it's just a standard DB that I am writing to use to quote projects. I have done everything in setting up this DB as I had done with the previous DB's in Access 2003, so that is why I was confused that I had this problem. The file is very small since I haven't started...

I've been creating a basic db in Access 2007. All the other db's I've previously created have been in Access 2003 and I have been able to open up the Microsoft VBC window and actually see the code after I have created the forms, queries, tables, links, etc. From some reason, when I open up...

Deleting the input mask did the trick! Thank you very much1

I am using Access 2007 and I have had a curious issue arise. I like to use the Date Picker feature on all my forms to make it easier to enter dates. I have set up each table's date field property to "show date picker for dates", as per attached (.jpg) When I use that particular field in...

Code worked perfectly. Thank you very much for your help! Another quick question, I assume you picked Chr(34) because that will allow an apostrophe as a wildcard....is the a list of Chr(??) someplace that will cover allowing other special characters in a search? thanks.............Mark

Here is my original code. Would you be kind enough to edit it so I understand where the new code goes? thanks. Private Sub GCFirmButton_Click() On Error GoTo Err_GCFirmButton_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "GC Names" stLinkCriteria =...

I have a program that has a "GC" Button that I click on which takes me to a General Contractor Form. It works perfectly unless the Firm has an apostrophe in it's name. For example "D'Agostino". (refer to attached DAgostino1.jpg). When I click on the GC button, I get the attached Syntax error...

(I read your signature line so I will tell you what I want to happen! lol) Not sure what you are driving at with your answer. I think my data structure is pretty sound. The table with the Main ID stays the same. Just two different update queries on the same table. 1st query updates...