Search results

Would anyone be able to tell me if it is possible to hide code within a database. I want to get the db to quit on a command but not want the code found. the db is not protected in any way or levels. Thankyou Nick

Could anyone tell me how to keep the date format in VB. I am trying to add a command which will happen after a certain date and enter the date UK style like 13/052012 but it always changes to 05/13/2012 and therefore will not work ! You help appreciated rgds Nick

Good morning all. Could anyone help with the following please. I am working in access 2007 and on my form I am entering in a date and time, in two separate control boxes. When I enter the control a small Date pane appears where I can then pick my date. When I next go to my Time control the same...

Good morning all, I wonder if anyone could tell me if it is possible thru code to auto copy a D/B on closure to another area of the PC, say to Docs/Mine. I guess I would be looking at an "on Exit" event.Or maybe not ? Your advice most appreciated Rgds Nick

Good morning all I wonder if you could help with the following please. I have a subform where entries are made for members of a club Part of the entry is to show whether a memebr has prepaid or not. Like this If Me.card_issue_Subform!ShootType Like "prepaid" Then etc etc. Could you show me...

Good Morning all would anyone be able to help me about a Q on security please. I am trying to make areas of my database secure but have a little success in understanding the various levels of the process. Is there a book or easy to follow manual / web site which goes thru the process so that a...

Good morning all I wonder if anyone could tell me please if I can save data to a duplicate table (with a different name) I have below taken from the Save button and wondered if I could add something to save to the other table at the same time ? My new table is Scores2. Many thanks Nick...

Good morning all I wonder if anyone could tell me if it is possible to filter out the number of lines in a list please. Basically I have E.g.50 results of a competition but I only want to show the top 6 of each class. Is it poss to only show these 6 top scores ? Like Class AA (top 6 scores)...

Hi everyone, I wonder if anyone has experienced the following: when printing a report on an HP Laserjet , when I send the print I have to press the "print" button on the printer to actually get the print. But this in only in Access. Anything else like a "Word" doc will print automatically. So...

Good afternoon all would anyone know how to create a second or third line of text in a message box. At the mom it all appears as one line. Also is there anyway to enlarge the text please. many thanks Nick

Could anyone help with a piece of coding please. I am trying to enter on a subform an "if Isnull" which refers to a control on the main form. Like If IsNull (mainform!member) then messagebox etc But cannot get the sequence correct. Can anyone help me please. Rgds nick

Good morning Could you help with a piece of code please. I have a Subform on a form which holds names of club members, the subform which is derived from a query has a "Next record" button which brings up the records as I click. my question is can I make the record on the main form change as i...

Good afternoon all could you kindly help with the following pls. If Me.Card_Issue_Sub_Form_Subform!ShootType = "Ladies Prepaid 60" Then MsgBox " Please Check Membership Card Punch Holes ", 48, "CHECK MEMBERS CARD !" ElseIf Me.Card_Issue_Sub_Form_Subform!ShootType =...

Good morning all Could anyone advise me on the following please. I have a sub form on a from which is showing as datasheet. When I open the form it autoselects the first record in the datasheet. I need to be able to select / edit the records but on open I need to select the next empty record. I...

Good morning all I wonder if you can point me on this please. I have a query with 6 fields in all and one of the fields is a Count of Date this works ok and shows the total, but I want to select certain dates and when I put say between Date() and Date()-160 it returns nothing. I think I...

Good afternoon Could you kindly tell me if I can re-arrange the info in a report. I have a report with results, and the results are with classes, AA , A, B, C etc The report always shows the A class first then the AA then B etc. Is there anyway I can tell it to produce the AA firstly then the...

Can anyone please help. I protected a database and wanted to install it on anther pc. This did not work and I could not open it. The new pc also then asked me for passwords for another database which is unprotected. I have even tried re insatalling access 2003 and still I cannot transfer even...

Good morning Could someone kindly show me how to show only the highest numbers in a query. I have a table with "scores" and am trying to show only the top 5 scores on a report. Is this possible ? I have looked at the Max total but that doesn't seem to help much. Many thanks Nick

Good morning all I wonder if you can help with the following please. I have a sub form which is in datasheet view on another form and when I enter details on the subform I would like to print a report on click of a button. The problem is that the report is empty of thos details unless I...

Good morning all i wonder if anyone out there has had this problem with access. I have created a d/base with colors and formatting on text boxes and background colors etc but when I transferred this to another laptop the colors did not transfer. Well some did like the rectangle surround to a...