Search results

Hi, I have a table with the following fileds: ID, Name, DOB, Ref Name is in the Form: Forename (Initial/Middle Name) Surname I have a form that lists all of this data, but I need to sort by Surname. How would I go about it? Thanks

Does anyone know the reason why on most machines, the common dialog box opens when called, but not on other systems. I'm calling: MSComDlg.CommonDialog.1 However, when edited, it comes up with an error stating: There is no object in this control. This only occurs on a handful of machines. Is...

I'm trying to set up the path for my images to be set in a table "General Settings" I've tried the following code with no success: Me.Text8 = tables![general settings]![img path] & Me.ID & "_1_" & Date$ & ".jpg" but it doesn't work! Any ideas?

I'm trying to base reports upon various data to be used for statistical analysis. Presumably these reports need to be based upon queries. I'm about there with what I need to do, but am not sure. Below are a list of queries that I need to find, but I need to find the number of rows / records, not...

If Access has the following limitation: Max users connected to database: 255 and MSDE has the following limitation: Only five concurrent batch workloads or 25 concurrent connections for websites is it worth upsizing using msde as I need up to 40 connections. Cheers

I'm having difficulty in viewing pictures in a subreport. The related table lists 5 pictures: photo1 -> photo5 Their fields hold the link to their location. Here is a previous post with more information if necessary: http://www.access-programmers.co.uk/forums/showthread.php?p=267539#post267539...

I have 4 tables, each dedicated to a different level of personel. These need to be discreet! The other functions that I use them for wont work if they are all in one table. I need to generate either one of the following: 1) Either a list of all of their names, pulling from each table. I've...

I need to be able to type in a 10 digit number as a reference. I can't seem to be able to type in a number above 1999999999 Any ideas? Thanks

This is my problem, and I can't solve it! My parent table/form is "Consultation". From this there are many subforms all linking to their respective tables all linked to "Consultation" via their ID (primary key). They are used for the different outcomes or requirements arising from the...

When compacting DB, is there any data loss? Is there any advantage in having it full size? Also - what does it do? (My DB is 97MB at the moment, 1.9MB when compressed - what happens??!!) Cheers

Here's my latest problem! For regular readers, you may have noticed that I've hit a few brick walls here all at the same time! I need to be able to select a file, upload it to a predefined folder and link to it all in one. So, from the user end, Browse -> Select FIle -> Copy file to...

Does anyone know anything about converting access to a standalone app such as Java, or VB with an SQL backend? At somepoint I'll need to upgrade it to SQL, and a VB front end would be easier! More to the point, as I know something like this does exist, is anything any good? Is it worth doing...

Okay - here's my predicament! I have 4 tables, each dedicated to a different level of personel. These need to be discreet! The other functions that I use them for wont work if they are all in one table. I need to generate either one of the following: 1) Either a list of all of their names...

Hi, I've a problem whereby I have a form with various embedded subforms. When I design my master form, all of the subforms look justified and normal as they should. However - when I open the forms in normal view (ie using the application), they appear as tables. This is probably something really...

Hi! This may be a tough one. My knowledge is not sufficient enough to achieve it! I have a Form linked to a Table. On this form I have several groups of fields seperated by tabs following the format: GroupA_active (yes/no) GroupA_notes (text) GroupA_actions (text) then on the next tab...