Search results

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...

I have a db where I import building reports on a daily basis. The initial report has numerous fields that are filled in the first time the report is downloaded into my db. The firm I get the reports from has the same Main ID#, i.e. 201400567891 that remains the same, but the Version number...

Finally got back to addressing this issue and your suggestion to look at the order by property did the trick! Thank you very much! :D

Thank you for your answer Paul. As I mentioned, I have never used VBC, so where would I put the Text string above in the following routine? Private Sub Open_Job_Process_Call_Report_ASI_Group_Click() On Error GoTo Err_Open_Job_Process_Call_Report_ASI_Group_Click stDocName = "Job...

I successfully set up a query that will pull the information I want. I have developed a report that when I open it manually works perfectly. [Job Process Call Report ASI Group] The issue is that when I try to make a command button to open up]Job Process Call Report ASI Group] I get a compile...

thank you for your kind offer, however this is a HUGE db and it would take me forever to strip the date down to a point where I could attach the file. :(