Search results

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 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 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...

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...

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...

Hi all, I have a sort of menu form which, when initially opened, opens several other forms but hidden, this works for most of the forms, but I recently added a new form to the dbase and it doesnt work! heres what I have in the on load of the menu form: DoCmd.OpenForm "first form", , , , ...

Hi all, As part of my ongoing project, I now have a form whos data source is a query which is a sort of lookup. The form is continuous, and all is working well, BUT, I'd like a txt box on each record displaying the curent record number, I searched high and low to try and find this, but to no...

Hi all, I created a small dbase today for a friend at work, nothing special, just a sort of calender/planner, I created it in access 2000, put it on his system - office xp, and got the typical screen about converting it, but then an error occurs, it wants to make a backup, so I make one, then...

Hi all, I've been securing my dbase by disabling shift/f11 etc which all works fine, only now my "admin mode" wont work! the code I use to disable toolbars etc is : Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i but when I do the OPPOSITE, from the click...

Hi all, Im currently trying to speed up my db, and Im stuck on a bit! What I have is a table with 14 fields, on a network share, the table has a lot of records, and what Im trying to do, is drag over to a local table, via a query, the records I currently need, the query runs and shows the...

Hi all, I have just about finished my db, the back end sits on an nt4 server, the fe's on nt4 workstations, now when I test this at home, its perfect, even with 200k records in it, its pretty fast, but at work, its SLOW (even with only about 10000 records), the basic setup is that the user...

Hi all, Just finishong of a dbase, which has a snapshot viewer control on one of the forms, works fine on my system, but when I try it on another system, the second line of code gives an error about mising references (the line is nothing to do with snapshot controls! its lbluser.caption=UCASE...

Hi all, I'm trying to edit some data which goes into a table via a text box, however, as soon as I try and use a variable for the text, it takes the first 255 characters then dumps the rest! is there a way around this? TIA CALV

Hi all, I have a lsitbox, but the amount of info in it is quite big, and somewhat cramped, is there a way to change the hieght of the rows? each item is between 10 and 300 characters, what my idea is, is to display part of it in the listbox, then when clicked, transfer the data into a textbox...

Hi all have a databse I made a bit ago (with plenty of help from folks on here!!), only now they want an update :( The database basically logs jobs, when a job is booked, the date etc are put in a table, along with a job_status field, this status is initially set to "pending", once the job is...

Hi all, Probably simple question, but Im stuck! I have a subform on a main form wich is basically a list of parts taken from table "parts", there are 15 text boxes called "parts1","parts2", etc with link to the data in the table. I want to set a for..next to examine these, if they are blank...

Hi all, Have a main form with a subform, basically the suer selects parts used on the main form, these are then transferred to the subform whos value is stored in table "parts_used", however as the "accept" button is clicked on the main form, I need to count the parts_used and enter the total...

Hi all, Im stuck again :( The part im stuck on is this- I need a list of parts (from a table) displayed in a list so the user can select the parts used, what I want is to dbl click on the part from the listbox and then transfer this part to another list box (or whatever) so I can store this in...

Hi all Doing some work on a database both from home and work, at home, I start typing, for eg "docmd." and then a list pops on, and stays there allowing you to select from the list and press tab to accept it, however at work, the list sort of flashes on then disapears! also at work, it tends to...

HI all, GOt a subform on a main form in continuous form view, all working fine (almost!!) but the subform is in order of ID (autonumber) I would like this in REVERSE order, is there a way to do this ? TIA CALV