Search results for query: *

I have linked databases that may be on different drives, as with another post. I write a macro to link in tables but if the table exists already, then Access creates a table appended with a number. So I preface every link with a delete but then the macro stops if thew table doesn't exist, and...

I am trying sub-reports for the first time and can't see where you connect them. Roughly I have a main report say Country, City. I then have two sub reports say City, Customer and City, Supplier. All three work ok separately. I drop the two sub reports onto the detail section of the main...

Maybe there's something I don't know but what I can see of Access is the editor is truly awful. You can't re-size the display. There's no search-and-replace etc. So I tend to use Word if I have some intricate SQL. I just hit a wierd problem where WHERE SOMETHING = "R" kept throwing a dialogue...

How do you select those rows which have a value that appears also in another row ie something like Select EMPNO, Firstname, Secondname where Count(Secondname >1)? I want to list the details of items that are probably duplicates.

I've got this code Sub AssignAtlas() 'Add incrementing Atlas numbers to those items without a number currently Const CONNECT_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=g:\Inventory\InvHPD.mdb" Dim Connection As New...

I have a table of people. I view this through a query People Maintain. I created a simple form People Maintain Subform. In design this works fine in either datasheet view or a form view. I drop this subform onto another form Maintain People. This now works fine but I can see no way of...

I have an app (someone else wrote it) that displays items for lots of people. I would like to display only those connected with the user. ie something like WHERE T1.USERID = NT_LOGON_ID. I can't see anything in Help. Any suggestions - I want to avoid them having to sign on to the app.

In an Access 200 query, if I do this it works: Slash2: InStr(1,[Filename],".") If I do this it returns zero: Slash2: InStr(1,[Filename],"\") I can only assume some escape sequence is required. Any clues?

In Access 2000, whenever I try to print a query it returns to page layout default which means that most queries stretch across many pages with masses of wasted space. Reformatting the borders and using landscape helps but these settings are never retained. Any suggestions?

I've got some modules working but it still seems entirely hit-and-miss. Sometimes an event procedure calls a module and it works, othertimes VBA says it doesn't know about the procedure; other times two procedures seem to be run. My problem is I can't understand the model for source code. In...

Is there the ADP equivalent of an MDE ie can you compile the Access part into an executable?

Anyone seen these Access file extensions? .mad Microsoft Access Module Shortcut (Extension not visible) .maf Microsoft Access Form Shortcut (Extension not visible) .mag Microsoft Access Diagram Shortcut (Extension not visible) .mam Microsoft Access Macro Shortcut (Extension not visible) .maq...

I'm having to write a review of Access and how it might appear on corporate infrastructure (desktops, file servers and application servers). I'm thinking of these: Vanilla self-contained application with Jet - mdb on desktop/file server. Front-end/back-end split - both mdbs. Compiled...

I have a table of servers and a table of applications. I might want to record that 7 applications run on 4 servers. I don't want to manually enter 28 rows in the AppServer intersection table. I'd like to select the 7 and the 4, and have the 28 generated. Last time I did this by writing a bit...

I have two tables with names - Firstname and Surname. If I do the following: SELECT T1.Surname, People.Surname, T1.Forename, People.Firstname FROM T1 RIGHT JOIN People ON ((T1.Surname = People.Surname) AND (T1.Forename = People.Firstname)) ..it runs alright but says it "can't represent the...

I had a query which worked fine so I've tried to move it into a module but the IDE complains. It says something like "expected end of statement" and highights the bold bit below. DoCmd.RunSQL "INSERT INTO Inv_StaffList ( Surname, Forename)" & _ "SELECT...

If you drag a field from the field list onto a form, Access will generate a data control and a label control. I've obviously done something because my form is defaulting to big labels with large fonts. This is a fag because I can copy the required style from another control but that still leaves...

I'm ploughing my way through Viescas but still haven't quite got how Data Access Pages work. It looks like Access/you generate html pages with embedded scripts that use a Windows service - MSODSC Object - to directly connect to the Jet database rather than via the usual route of sending form...

I have this simple one-table query: SELECT People.ID, People.CompName, InStr(1,[CompName]," ") AS Sblnk, Len([Compname]) AS CNlen, Mid([CompName],([Sblnk]+1),([CNlen]-[Sblnk])) AS Surname, Left([CompName],([Sblnk]-1)) AS FirstName, People.Group1, FROM People ; It picks out surname and...

I have a list of items I would like to display grouped by a grouping field, with the grouping field displayed as a sub-heading. This is the sort of thing you can easily do on a report. However I want to allow the user to double click on an entry and have a full screen form appear showing the...