I am running Access 2003.
How do I import a variable length text file? The fixed part of the record contains demographic information and the variable part is a two character type program field and two date fields.
Thank you.
I have Office 2003 at work and Office XP at home. I have an option to save to workspace but no option to save to my Office Live workspace on any of my office applications. I searched MS for an add-in but can't find one. How do I save my office documents to my Office Live workspace?
I have a table that I run a select query against it and then I run the same query as a delete query against it. What I am try to do is separate out the records that join with the SSN table from the main database and then delete them from the main database. Then I have two tables one contains the...
I stumbled across this and it worked.
1. Open the properties window on the query in design view.
2. If the 'Unique Records' property is set to No. set it to yes.
I did the above and my query worked.
Leslie, thank you for the alternative solution.
I am trying to delete records in [Tile Undup work] based on SSN match to SSN in [Title SSN Match]. Access will let me delete all of the records but when I add the join I get an error that says Could not delete from specified tables. What am I doing wrong?
DELETE [Tile Undup work].*
FROM [Tile...
Our mail merge uses an access query as its data source and it had been working fine for a couple of years. Yesterday one of the users said the mail merge stopped working. My research revealed that the mail merge can no longer see the query. It can see the intermediate queries but not the final...
We are running Access 2003. My database had a few blank possibly corrupt records that generated a run time error 3709 every time I tried to delete one of them.
I ran a compact & repair. That did not delete the records but apparently it repaired them sufficiently to delete them by hand.
Here is the SQL code. I can't see anything wrong with it but it never goes to end of job. Could the problem be that the field being updated is also the join field?
UPDATE [Title XX test] INNER JOIN [Provider Xref] ON [Title XX test].Provider = [Provider Xref].Clinic SET [Title XX test].Provider...
I have several update queries that all update the same field and I couldn't figure out how to combine them, so I came up with the idea of creating a separate cross reference table. The idea was to join the tables on the provider field and then replace the current provider in the provider table...
Our database has five users. The main form they use is a data entry form that has a name search function. The search function is called by pressing the name search command button. The command button applies a filter and opens the data entry form. The query brings up a text box to enter the name...
I need to select 75 patients for each doctor in my database and with your help I got that working. The query results delivered 75 patients for each doctor. Now I find out that the requestor wants to select 75 random patients.
There are 4 doctors in the database. Each doctor has several hundred...
I have a doctor table with doctor and patient ID's. I want to select 75 patients for each doctor whose insurance date is currently still active. How would I do that?
Doctor Table
Doctor ID
Patient ID
insurance begin date
insurance end date
My actual application is kinda complex, so let me give a simplified example. Suppose a user wants to know how many new hires were placed in each corp. division over a given time period and they want to know the count for each division even if it is zero.
In the application the user enters their...
I have report that I start with a command button on a form whose record source is a series of queries. The first query may not find any records. The last query that feeds into the report always has records regardless of the results of the first subquery, so the 'no data' event does not work.
If...
Auto-number is recycling in our Recipient table. It counted up to 2032 and now it has gone back to 1 and restarted its count. As far as I know nothing has been done to the table to cause it to restart but now we have duplicate auto-numbers all the way up to 845.
Any ideas on what caused this? I...
My form lets the user select a specific funding source (FS) or a selected group. There is no specific FS = 060 (valid FS = 020, 055, 056, 057, and 58), so I used 060 to indicate that the user wants a selected group of funding sources. In the criteria box for FS I inserted...
My database has one table with lots of data elements. Instead of making one looooooooong data entry form, I created a subform for each data category. My main form now consists of 5 subforms one for each category. When I click on the tabs, page 1 is looking at one record and all of the other...
If you have multiple indexes, how do you select which index you want to be the current index or no index at all and have the database reflect that order?
I'm a bit confused about how those work:
field1 field2 field3
aa 12345 333
aa 34567 444
aa 45678 555
Using the above:
If I do a select distinct field1,field2,field3 I will get all three records because they are not exact duplicates, right?
Now...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.