Search results for query: *

This is an image of the error that I am getting when I try and link a Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server...

Hi There - I have a form made using front page. It was working fine, then all of the sudden after submitting the form, it requested a login and password. beth@integratedresourcemgmt.com

Hi There - I am trying to create SQL statement in Enterprise Manger where the columns are combined like: [FirstName] & " " & [LastName] AS Expr1 It gives me the error: "invalid column name". Is there a way to combine columns that anyone knows of? Thanks, Beth beth@integratedresourcemgmt.com

Hi There - I am trying to find out if it is possible to create a query in an access data project (.adp) located on my computer that links to a sql database. I was able to generate a query in Enterprise manager, but couldn't figure out how to save it. I am unsure, but I guess the routine would...

Hi - I was able to get my system to delete multiple tables, but now I need to import multiple tables from an .adp. named "sql_db". Is there a way to import all the tables from this database at one time? I am going to search around, but if anyone has any information or can help with...

Hi - Is there a simple macro or query that can be run to delete all the tables in a database? Thanks, Beth beth@integratedresourcemgmt.com

Hi - I need to figure out how to import access tables from one database to another using a macro. I set the action on the macro to "RunCommand" and at the command line I see an option to set it to "Import". Now I just need to figure out how to import some tables from...

Hi - I have a client who is using outlook 2000 to retrieve email from multiple email accounts from a Pop3 email server. All of the sudden, they are unable to receive email. It appears like the mail is incomming, but seems to hang. We switched them over to Outlook Express and set up the email...

Hi - This is probably very simple, but for some reason, I can't figure out how to do it. I need to sum F:4 to F:1843 *27% for each row and put the % into H:4 to H1843 for each row. Is this possible to do without performing the calculation in each cell? Thanks, Beth...

Hi - I have a field named "Field6". I have been able to parse out the Left two digits in my query in Access by using the following syntax: new3: Left([Field6],2) Now I need to pull out the middle 5 and the last 4. I thought I could get the middle 5 by using: new6: Mid([Field6],5)...

Hi - I have a table named "TESTNEW" there is a field in this table named "CustomerID". The data in the "CustomerID" contains 6 numeric digits i.e. "000049" or "000205". I need to run a query that will delete the last digit from the data. I...

Hi - So ... What's New at Yahoo!? In a press release dated 12/23/02 Yahoo! announced that it will purchase the Crawler Based Search Engine Inktomi for approximately $235 million. Inktomi currently provides its' data to: Overture, HotBot, MSN, About & Looksmart and lists 2 Billion+ websites...

Hi - I have a field in access named "readLastDate" that contains a number, for example: "721486825". I need to make this number a date, but not only do I need to make it a date I need to add this date to the number "1\1\1980 12:00:00 AM". So "721486825&quot...

Hi - I think this should be easy, but I am not getting anywhere with this. I have a field in a table named "CustomerID". I have set the properties of this field at Indexed to "Yes (No Duplicates)". I have a form for users to enter data into this field. The form does not...

Hi - I have a database with a table with one field "CustomerID" where the properties have been set at Indexed to: Yes (No Duplicates). While this does work, if you go to add a duplicate record on a form it simply does not save the record. Is there a way to set it so a message box...

Hi - I am having a little trouble. I have a calculated field on the footer of a report. The field is a text box containing the following syntax: =Sum([Txt999]) I want it to sum the value in the text box in the report named "Txt999". When I run the report it prompts me to enter a...

Hi - I have a text box on a report that where I need to perform a calculation based on criteria. I am looking to calculate this: IIf the field "desc" is null, then I want to subtract one from the dataset. So, this is where I am at: =IIf([desc]=Null,-1) This is returning blank, so I...

Hi - I have a query with a field named "othrsr", which returns both positive an negative numbers. I want to return all the negative numbers as positive. I try adding "Abs([othrsr])" into the criteria and that restricts the data set to only positive numbers is there a way in...

Hi - I am having trouble getting some Access 2000 append queries to run on a windows 2000 machine. I have .dbf tables linked into the database via ODBC and the data is displaying, but I can't get the queries to run more than once without them freezing. I can get the queries to run on both a 98...

Hi - I have a few .dbf tables linked into an Access database via ODBC (visual fox pro). Sometimes I can open the tables and sometimes I get the error: "Could not execute query, could not find linked table. [Microsoft][ODBC Visual FoxPro Drive #173]." There are no other users...