Search results for query: *

In my VBA codes I used the saved specification to import text file which worked fine, but after I edited specification manually, it doesn't import data into Access database any more. Could you please tell me how to fix the problem? Thanks in advance!

I have two tables (table1 and table2). Both have common fields such as LName, FName and ssn. LName and FName in table1 are blank. Now I need to insert FName and LName from Table2 into Table1 (where table1.ssn=table2.ssn). How can I accomplish this? Thank you in advance

I have a form that is linked to a query. The query is created based on the tables which are linked to SQL server. I have set the form’s data entry property to true. But somehow, when the form opens, it is still filled with the data. I have tried: Docmd.openform “formName”,,,, acformAdd, and it...

I have encounter 2 problems while doing the mail merge. 1. when the doc opens from Access form, it only contains ONE record from my user's machine(should be more records showing on the different pages). 2. If the date filed is blank in the source table, the doc will show...

I have a field called dtDate in the table, when there's no dates in the field at all, it shows a blank on the form. I'd rather to assign a value to it, as below, but it doesn't work. Can you help me with this? IIf([dtDate] is null,Now(),[dtDate]) Thanks!

I tried to find records by using last 4 digits of ssn in dlookup() function, but somehow it didn't work. Can I use the function for partial searching? Thanks for your advice! strLName = DLookup("lname", "MyTable", "[SSN] ='" & "*" & Forms![FindForm]![txtPartialSSN] & "'") If IsNull(strLName)...

I am using Access 2000. I have a summary report which needs to show total counts of each category. On the report there’s a field called PG13Rated (text datatype, which has a value Y or N). I need the report to show how many Y (N) in each category. Is it possible to the do calculation on the...

Good morning, everyone! I have a sql statement SELECT TOP 20 WITH TIES ssn, LName, FInitial, SUM(hrsWorked) AS [Total HrsWorked], SUM(amtEarned) AS [Total AmtEarned] FROM MyDetailedTable GROUP BY ssn, LName, FInitial Order by SUM(hrsWorked) desc, SUM(amtEarned) desc I need to have a...

I have created a stored procedure with parameter in SQL server 2000. How can I execute it from Access. Thanks for your help!

I was trying to create a work group for certain Access database(which I set up the password), but the problem now is whenever I need to open other unsecured database, the log on form still pops up for me(even I join default workgroup system.mdw). How can I get rid of this? Please help! Thanks in...

I have a field with value -1 ,o or null. I need to show those records which has value -1 as Yes, the following codes always gives me an error on the report: =IIf([Graduated]="-1","Yes","") Could you please give me some advice! Thanks in advance!

My backend database is located in SQL server, from which I have a few Access databases table( front-end) linked to it via ODBC. Is it a safe that I share the same DSN when I make a connection via ODBC for each front end database? Or should I make different DSN to get connected. Your opinion...

I have Access as FE, and SQL server as BE via ODBC. The tables are all linked. The server is using SQL server Authentications. In my Access form load event, I will check each user’s NT id to make sure if it’s matching the id of Usertable at BE, if not, a msgbox will say sth llike“You’re not...

I have Access as FE, and SQL server as BE via ODBC. The tables are all linked. The server is using SQL server Authentications. In my Access form load event, I will check each user’s NT id to make sure if it’s matching the id of Usertable at BE, if not, a msgbox will say sth llike“You’re not...

I have a continuous form which shows SSN, fName, LName from Table1. Also on the form I have a command button which will be enabled when it finds the same ssn in Table2, otherwise the command button will be dimmed out when there’s no SSN matched in Table2. But the command button doesn’t work the...

Recently our users' computers were upgraded. but somehow they can't use the Access system simutaneously any more: Whenever more than one user tires to access the system, the system no longer permits it. Only the initial user can gain access. All others are given the message” the system has...

I need to delete the data of a table which is located in another Access database. How can I do it? I have done some research, but not much help... Thanks in advance!

I need to delete the data of a table which is located in another Access database. How can I do it? Thanks for your help!

The following codes will transfer the text file into my database. But if I run this code again, it will append the records to the existing table again. I want to check the database to see if there's such a table, if so, I will delete it and then transfer the text file into the database. Is it...

I have to convert Access 97 to Access 2002. Since the database of 97 is secured in a workgroup, I can not convert it into 2002 by wizard. So I have to manually export each table (query,form, report…) into Acees 2002 database, which won’t be secured by any workgroup. Can you tell me an easier...