Search results

fixed it, just needed a MeasureItemHandler

Hi all, been trying to sort this small problem fo 3 days now I have an ownerdrawn listbox which displays an icon next to the item, and displays the text in a different colour. All working fine as a standard sized listbox but if I use a larger font then the text doesnt display properly and it...

Hi, Thanks for the reply, I did look into setting the autonumber to random but that still left me with the problem of possible duplicae jobID's since I only use 4 (for now) of the numbers, I'll read up on replication tomorrow and see what I can come up with, at least I have a starting point now !

Hi all, Got my job database going quite well, at the moment, it generates a job number form the first 4 letters of the customers name, and the ID (autonumber), so for example mr smith's job number would be SMIT0012 (assuming the 12th entry in the database) Now this works fine, tables are linked...

Hi, Thanks for the reply, I'll try renaming. In the meantime I found a dirty workaround, I public'd a variable, then when I click the button to open my report, I set the variable to the field value of the jobref, then I filtered the report by that variable - not ideal but it works.

Hi all, I have a problem in a database I'm designing at the moment. Basically I have a form (frmMain) which is filtered (from another form). I can then go through the filtered records no problem. I made a query, and also a report based on this query. The query has all fields from the main...

Thats brilliant, thanks very much indeed. CALV

Hi, The problem is, it NEEDS the duplicates, though they also need to be filtered out at times. Thanks CALV

Many thanks, there is actually nothing to the db at the moment, what I need to do is filter at the query stage as this data will be used later on (actually it will be accessed from an ASP page) I cant post the actual db as its at work but I have put together a small one with the problem. What I...

well really I need quite a bit, I need the UID, ID and several other text fields, but no duplicates on the UID, so it just lists the one if there are more than one with the same UID. Thanks

Yes I tried putting GROUP BY but then it applies to them all and doesnt make any difference, or am I missing something here? Thanks CALV

Hi all, Im having a major brain lapse here! This is what I need to do: table consists of ID - Autonumber UID - number other- text several other text values Now the UID field will contain duplicate values, if this is the case, I need to list only the FIRST one of them, i.e. if the table...

Yes, It is (was!) a dead simple thing, part of it involved reading info in from a text file, now the location of this file varies from system to system, thats why I needed the open file dialog. Also It had on it a timedate picker control - this also had references problems.

Hi, I looked at your suggestion Wayne, you may recall you helped me out with that before, the problem was, I didnt have the OCX's handy. Pat, I used that method in a previous dbase (cant remember why), the problem was, I ended up with a whole lot of code that I didnt understand.

well, I gave up! rewrote the front end in VB, took less than an hour, stupid that you need to do so though, and of course not everyone has vb. CALV

Thanks for the replies, I am using 2002 at work also, I've just applied SP2 but still doesnt work :( I'd be happy to re do it in 2000 but everyone here uses xp so I'm stuck with it.

Hi all, Created a very simple dbase at home (access 2002) and all works fine, brought it to work, got 2 mising references:windows common controls 2-6-0 (MSCOMCT2.OCX) and Microsoft common dialog control 6 (COMDLG32.OCX) So I removed the ticks from the references, and tried to add them again...

ok, I had a similar (actually the same) problem, heres what I did: Create a logon script for the 6 users in question to copy over the FE from the server to the users desktop REGARDLESS of wether or not a new version exisits, this will ensure that at each logon, the latest version will be on...

Your not the only one ! CALV

You mean you did: DoCmd.OpenReport ("report name"), acViewPreview ' open report DoCmd.PrintOut , , , , qty DoCmd.close acReport, "report name", acSaveNo Thats also what I've used, tho I do like using snapshot viewer so you can actually view the report on a form rather than opening it...