User Profile

Collapse

Profile Sidebar

Collapse
Newbie23
Newbie23
Last Activity: May 18 '10, 07:29 PM
Joined: Jan 17 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Newbie23
    started a topic How to get Mac Address
    in Perl

    How to get Mac Address

    Hello All,

    I am a total perl begin who is trying to put together a simple program to collect information on a local machine. I have managed to gather everything i want except retrieve the Mac address... and its driving me insane. All i need is the simplest method of getting the mac address, I have looked at a few perl modules and cant get anything to work or the module cant be found. Is anyone able to help me?

    Any help...
    See more | Go to post

  • Newbie23
    started a topic Display Menu
    in Java

    Display Menu

    Hi All

    I'm a total newbie to Java.

    I'm creating a very simple banking system as a college project. I'm doing ok... logging in the user, the displaying a Main Menu with options to select from. However Im using a If statement for the selection and once I have selected an option (for example = check account balance) I cant go back to the Main Menu (unless I write the whole thing out again, which would be daft).
    ...
    See more | Go to post

  • Newbie23
    started a topic Merging Access data with Word

    Merging Access data with Word

    Hi All (yet ANOTHER question)

    The reason for the merge is to create a Quote letter for the selected customer. It's working fine except for the contact address not showing. I have re-written the code, double checked the names and complied it. (I have attached a screen shot of the letter produced). All the other fields are merged into the letter fine but just not the 4 address lines?!! My code is as follows:
    Code:
    Private Sub cmd_MailMerge_Click()
    ...
    See more | Go to post
    Last edited by NeoPa; Apr 24 '09, 05:04 PM. Reason: Please use the [CODE] tags provided

  • Newbie23
    started a topic OK & Cancel Buttons

    OK & Cancel Buttons

    Hi All... yet another question : )

    I have a few forms for adding data where I have and OK cmd button and a Cancel cmd button. On the OK cmd button,if there has been no data added I would like a msgbox to appear (Please complete the job record... or something along those lines). The code I have is as follows:
    Code:
    If Me.Dirty = False Then
        MsgBox ("Please enter the details for this job."), vbExclamation, "Missing
    ...
    See more | Go to post
    Last edited by NeoPa; Apr 24 '09, 10:34 AM. Reason: Please use the [CODE] tags provided

  • Newbie23
    replied to Combo Box Values
    Thanks for that, I have it working : )
    See more | Go to post

    Leave a comment:


  • Newbie23
    started a topic Combo Box Values

    Combo Box Values

    Hello,

    Am I able to change the values available in a combo box based on what value is selected in another combo box?

    For example, my form is to add a serviable appliance record, i.e. Boiler , Fire.

    I have a combo box to choose which type of a appliance, but then once is selected I want the next combo box to choose a manufacturer. Manfacturer, Makes and Models will differ between the different types of...
    See more | Go to post

  • Newbie23
    replied to Copy Control
    Hi,
    I've compiled my project as suggested, it has sorted one or two little querks I had (so thanks for that) but nothing with regards to this problem. I also tried exporteing to a new database as suggested I got the same problem. I'm stumped, I dont get any errors but it will only copy accross the last value. Any other ideas are more than welcome.

    Cheers
    Jane
    See more | Go to post

    Leave a comment:


  • Newbie23
    replied to Copy Control
    Ok well... I managed to get the debugging working and it highlighted the very first line of code. After reading the code myself I thought it would make more sense to swop the values round, so the code now looks like this:
    Code:
        Me.AddressLn1 = Me.Dyn_Addln1.Value
        Me.AddressLn2 = Me.Dyn_Addln2.Value
        Me.AddressLn3 = Me.Dyn_Addln3.Value
        Me.AddressLn4 = Me.Dyn_Addln4.Value
        Me.PostCode = Me.Dyn_Postcod
    ...
    See more | Go to post
    Last edited by NeoPa; Apr 20 '09, 04:03 PM. Reason: Please use the [CODE] tags provided

    Leave a comment:


  • Newbie23
    replied to Copy Control
    Hi,
    There is one form used to input property information, when this is loaded it populates the contact address on the form. On the same form I have to add details of any properties the customer lets. I would like a control on the form that will copy the contact address to the property address. this will be used rarely, however it will make the interface a little more user friendly.

    The only error I get is what I stated before...
    See more | Go to post

    Leave a comment:


  • Newbie23
    replied to Copy Control
    I know copying the data isnt the best way to do it.. but for how big the database will be and what it will be used for it's really not an issue. I just need to know how to create a copy control?
    Cheers
    See more | Go to post

    Leave a comment:


  • Newbie23
    replied to Copy Control
    Hi There,

    I have normalised my data to 3rd NF. However I need to copy this data to a temp table that will be used for reporting. Any help with how I can create a copy control button would be great.

    Thanks
    Jane
    See more | Go to post

    Leave a comment:


  • Newbie23
    started a topic Copy Control

    Copy Control

    Hi All,

    I'm trying to develop a control button on my form 'frm_initialPro perty' that will copy a contact address (5 fields) from my tbl_customer table to my tbl_properties table.

    The form shows a contact address for a customer that was input on a previous form. I would like a button to copy this data into the property address fields on the same the form. I have used the following code: (however I get an error 'You can't...
    See more | Go to post
    Last edited by NeoPa; Apr 13 '09, 04:47 PM. Reason: Please use the [CODE] tags provided

  • Newbie23
    replied to MS Access Forms
    Yeah I have used the wizzad to do this sort of thing before, However for some reason it wont work on th database. Where the wizzard asks to pick from two fields that will match, one of the columns is always empty and wont they you continue.

    Anyway, Im not sure I understand about how to amend the code I posted before?

    Many thanks for your help
    See more | Go to post

    Leave a comment:


  • Newbie23
    started a topic MS Access Forms

    MS Access Forms

    Hi All,

    Im currently trying to develop a small customer database but keep coming up against loads of little problems.

    At the minute I have a form with a data sheet at the bottom listing all customers and at the top are a few boxes that is populated when the user selects a record in the data sheet... If that makes any sense?!

    I would like to be able to open another form, based on the record that is selected,...
    See more | Go to post
    Last edited by NeoPa; Apr 6 '09, 01:05 PM. Reason: Please use the [CODE] tags provided

  • Newbie23
    replied to MS Access Calendar
    Hi Adezii.

    Sorry got carried away with getting the calendar all set up in my database. It's brilliant!! Thank you so much for your time and effort.

    Many Thanks
    Jane
    See more | Go to post

    Leave a comment:


  • Newbie23
    replied to copying records in a form
    Hi,
    I do have two seperate tables a customer table and a properties table (one to many relationship) as shown below:

    tbl_Customers
    *CustID
    CustName
    CustPhone
    CustConAddressL ine1
    CustConAddressL ine2
    CustConAddressL ine3
    CustConPostcode
    and so on

    ...
    See more | Go to post

    Leave a comment:


  • Newbie23
    replied to copying records in a form
    Hi,
    I have normalised the database and drawn up ERD's. I understand you have to prevent data duplication. However a customer may have many different properties (as well as a contact address). This is a one to many relationship that requires each property to have a seperate record, as this eventually leads to a servicing plan set up on this particular property. The contact address and property address are different data elements.
    ...
    See more | Go to post

    Leave a comment:


  • Newbie23
    started a topic copying records in a form

    copying records in a form

    Hi All.

    Was wondering if anyone could help me with this. Currently I have a form that creates customer details (Account Number, Name, Contact Address etc) when I hit the 'Next' cmd button it takes me to a property form. In the property form the user has to add a property address for the customer. The property address may or may not be the same as the contact address.

    So currently when I load the property form the account...
    See more | Go to post

  • Newbie23
    started a topic Access 2007

    Access 2007

    Hello All,

    When using Access 2007 should the VBA code behind the form be populated when I control is added. Im a bit of a novice with access but usually can get round using it fine but im having some problems as 2007 does not populate the code like in previous versions?!

    Is this just me?
    See more | Go to post

  • Newbie23
    replied to Linking tables
    Thank you I have it working now.

    also wonder if you can help me with this.
    When I open a create customer account form, I want the main menu form to close, same as when I close/cancel the new customer account form I want it to close then open the main menu. (as well as ask the user if they are sure?)

    This seems really simple stuff but i cant get it working !!!!!! aaarrgghhh!! ive taken code from a prev db i've...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...