Search results for query: *

Hi - what do I need to do to stop this happening..? Button opens a report from a maximised form. When the rpt is open, when I minimize it (which I'd like to be able to do), the form(s) open behind it have shifted down about have a screen (not minized) just moved. How do I keep my forms...

Hello, What method should I use to do this? I have a form with 2 unbound date fields on. The user inputs two dates and then clicks buttons to preview reports based on queries that use the two unbound dates. But the queries only work if the form is refreshed before the buttons are clicked to...

Hi. I have a list box on Form1 populated with fields ClientName, ClientID, with a cmd button to open in Form2 the record selected by the user in the list box. Form2 has a cmd button that closes it and opens Form1. When I add a new record in Form2 then close it with the cmd button to open...

Hi - I'm sure this is easy to sort out but I am a novice (still!). I have a report based on a query (which just pulls together lots of fields from one table plus a field [Ethnicity] from another query). I have a command button on a form that opens the report for that particular record, but if I...

Hi - can anyone help? I am trying to produce a report showing various record counts from my DB. Each record in my table is a Client. Table name: client_table Field names: ClientID (PK) HighQlevel (has 9 possible text values... none, level1, level2, level3, level4..etc...) Gender - male/female...

Hi, On a form I have a combo-box field (EthnicityID), bound to Client_table, its values are populated by another table, Ethnicity_type, (fields: EthnicityID, BME), in which for each value of EthnicityID there is a corresponding BME value (yes or no). For each record in my client_table I want to...

HI - Can anyone help me with this....I'm am completely confused now.... Here's what I have: Each record in client_table is a Client (ClientID is the primary key field) Field names in question: HighQlevel (has 9 possible text values... none, level1, level2, level3, level4..etc...) Gender -...

Hi - I am learning as I go in Access...so far so good, but now I feel I am not seeing the best way to do this. Each record in my DB has the following two fields: Qlevel - possible values 1 - 9 Dcode - possible values a - h I want to produce a query that will tell me counts of how many records...

Hi everyone. How do I do this? My user chooses a value from a listbox on Form1, and Form2 opens showing only the record chosen. I have a button in my form footer that removes the filter to showAllrecords. This is fine. How do I hide the button when the user opens Form2 directly to show all...

Hi there, I have a field called ClientID that is an AutoNumber. Is there a way I can have this number so that it is prefixed with a letter (that will remain constant)? Is this going to cause problems if this field is my PK? TIA Andrew.

HI - Anyone know why my A.I 8.0.1 is doing this when I try to save as PDF; "Adobe PDF File Format is having difficulties. Out of Memory." I am trying to save an EPS as a PDF. It usually does it after about 3 successful goes, and then brings up this error warning each time....sometime a reboot...

Hi People. Simple this I am sure but I not so hot with Access.... If I have a listbox (namelist) on form1 that is populated with values from one field of a table, how do I make it open the record that I select in the listbox in form2? TIA for any help. Andrew.

Hi - How do I get rid of the the vertical left hand bar (with a right-hand pointing arrow at the top) that appears on the left of each form/subform I create? Thanks! Andrew.

Hi - Can anyone help me with this? I have a DB recording clients that register with a jobs placement scheme. Client data is stored in Client_Table fed by the Client_Form. Each time an advisor interacts with the client, the interaction is recorded in an Interactions_subform on the main form...

Hi everyone. I have dabbled with Access at a fairly basic level in the past, but would like to ask a question on the best practice for building a particular dbase so that I don't go down the wrong path. If possible just some advice on what features of Access I should use and how I should relate...

Hi. Please help if you can... I am trying to open an .EPS file (a logo) in Mac A.I 8.0.1, but I get the message: "Cannot open the illustration. The illustration contains an incomplete or garbled object description. Offending operator Systemdict." This only happens with this and another 3 logos...

Hi everyone, Is there a way to make a text field size greater than 250 characters? Thanks for any help. I'm rather hit and miss with coding and all..... Andrew.

Hi I am using CSS on a site, but I am not sure I am using them quite as intended, or I am missing something. I have a style, headline1. i have: .headline1 a: link .headline1 a: hover .headline1 a: visited The hover class changes the colour of the link on mouseover, which is fine, but once...

Hi. I have 2 movieclips, both feature some buttons. In my main movie I want a button that is within movie clip 1, when clicked, to show and start the other movie clip. What is the best way to achieve this (in Flash MX) ? I am not sure about best practice in Flash so am getting in somewhat of a...

Hi - I am new to graphic stuff so go easy - I have an .eps file (a text logo - no paths or layers) that is white text on a black background. I need to use it whited-out in a quark file on a dark colour b/g. How do I make the logo have a transparent b/g in illust. or pshop so that just the white...