Search results

  1. J

    Copy over a csv file contents, to a new sheet in a excel file not opening csv file?

    Hi there. I was wondering if there's anyway of allowing a macro to copy over data contents for a csv file (the whole file contents, which accumulates to about 7,000 rows), without copying and pasting, also if its possible is there anyway of making it do this without even opening the csv...
  2. J

    Confusing Form problem

    Ok I have a real problem here. I have a parent combo box named 'cmb_cartridge_manufacturer' yea? (as its reffered to on the access 2007 form) I also have a child one thats called 'cmb_cartridge_select', when the user selects a manufacturer it limits the number of cartridges in the child combo...
  3. J

    Macro version of a CTRL+F function, for thousands of results (seeking alternative)

    Hi there, I have had soo much help from you members in the past, your help has been invaluable to me getting my employed work done, I really appreciate it! This is why I have turned to you again. But haha, I have another problem that I think some of you might be able to help me with. Is...
  4. J

    Requery problem sub select form problem I think

    Hi there, I have a bit of a problem here. I got working on a most workable solution for a form, now I will explain the situation before I explain the problem. I have a ink cartridge codes table, with an id field in there which relates to a manufacturers table. As I worked out there would be...
  5. J

    Text box not reappearing based on an if statement of a tickbox

    Hi there, Thanks ever so much for helping me out requery a form based on the adding of new entries and going back to my main form, its been a real help!! I am having one slight problem though. I have a tickbox, that when you check the tickbox, a file_location textbox appears, for the user to...
  6. J

    On close form update main form

    I am not sure if I have worded the title for this thread correctly. Here's my dilemma, I am pretty sure there's a away around this though, but any advice is greatly appreciated. I have a form, a series of drop downs to select printer cartridges yea? I want the user to be able to add print...
  7. J

    Perform a BETWEEN 2 dates from a form query

    I am not sure if I have phrased the title properly here. But I have 2 text fields. What I was wanting was some idea of how to get a database query working where it looks between 2 dates, all I require is the SQL syntax and if you can note what it relates to, that would be easier for me to...
  8. J

    Generate report from a dynamic form query

    Hello everyone, I am having some concept problems I just cant seem to get my head around at the moment so I would greatly appreciate your help. I have a very basic form query here, with a drop down (combo box) and the user submits by clicking a run query command. At the moment its bringing up...
  9. J

    If tickbox is ticked then must enter something into another field on a form

    How is the most efficient way to allow the following to happen: What I want is for when the user clicks an add record button. Is when a tick box named 'filed_bool' is ticked (I got the value back through a msgbox as being -1). Then the 'location' value cant be null. If the user forgets to...
  10. J

    Combo selection box 3 rows viewable problem

    Ok I have a combo box problem this time. Its much easier getting back to Access 2007 now I am getting more confident with it, its weird because I am so used to the higher end server databases, knew it wouldnt take long. Ok enough of the waffle here's my dilemma (excuse my spelling): I have a...
  11. J

    Combo box list, related form problem

    Hello I am new to this forum, I have a project for a database at my work and having some difficulties getting my head around how to do this. I have normalised a table and suddenly realised a problem with a form in relation to me doing this. Ok enough of the waffle, here's the problem: Ok I...
Top Bottom