Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. megavolt121

    Importing MS Word file into a table

    I have a word document with a table of Contents. I want to input the toc into my table. Is there anyway I can set it up to do this? My table of contents looks something like this: 1. MORE 1.1 more 1.2 moremore 1.3 moremoremore My table is setup with the fields: Section_ID <- My...
  2. megavolt121

    Importing MSWord file into database

    I have a word document with a table of Contents. I want to input the toc into my table. Is there anyway I can set it up to do this? My table of contents looks something like this: 1. MORE 1.1 more 1.2 moremore 1.3 moremoremore My table is setup with the fields: Section_ID <- My...
  3. megavolt121

    Security Problem

    I believe it created a work group file for me. this just happened after ms access was reinstalled. then again i'm not sure why the file(i believe system.mwb or something like that) was missing to begin with.
  4. megavolt121

    Security Problem

    I have security permissions via groups setup on my database. Now the other day Access crapped out and said a system.mdw file was missing so the tech support guys here decided to reinstall access. Now I can't reset any permissions! Is there any backdoor way into this thing so I can tweak it?
  5. megavolt121

    combo box using query

    I have a query that returns all of my results alphabetically. In my form I've created a combo box to display the results. So far it displays a combo box with only one entry in it, i have to click to the next page to see more. What i want is for all the results to be displayed in the combo box...
  6. megavolt121

    Listing a field to create reports?

    Oh yea, On top of that I'd like to make it so once the user selects the part, it automatically brings up the correstponding report for that part.
  7. megavolt121

    Listing a field to create reports?

    Gus thanks for the tip ont eh combo box. I've now changed my Part Name to type Text. I created a Query and had it sort alphabetically too. So i have one colum in alphabetical order with each part in its own row. Ok so now when I make the combo box, it shows me the first query result in the...
  8. megavolt121

    How should I do this?

    the only issue i have is that the table i'm grabbing info from expands. Is there anyway to make a form automatically refresh the info it has each time its called? I also need the info to be listed alphabetically.
  9. megavolt121

    Listing a field to create reports?

    I'm updating a database(duh). What I have is a table with an field named Part Name of type Memo. Then using switchboards, I have a switchboard that does view Parts. once in that switchboard i have the option to view all parts. now what i want to happen when i click on view all parts is for...
  10. megavolt121

    How should I do this?

    I'm updating a database(duh). What I have is a table with an field named Part Name of type Memo. Then using switchboards, I have a switchboard that does view Parts. once in that switchboard i have the option to view all parts. now what i want to happen when i click on view all parts is for...
  11. megavolt121

    creating reports

    Jim thanks a lot that fixed those problems and I think i'm getting the idea now of how to do this better, but I just emailed u one more question.
  12. megavolt121

    creating reports

    Sent to the mailto:webmaster@jmhare.com 558kb. 3:51 PM Pacific Time
  13. megavolt121

    creating reports

    I've now had another problem. In my first report, Parts, I put in: =IIf([Stage]=0,&quot;No&quot;,&quot;Yes&quot;) and it would print out Yes and No for all four fields I wanted. Now when I create another report and use the same exact code using data from the same table(just a different query)...
  14. megavolt121

    Computer Reboots in Access Reports

    check your RAM to see if they are good. Sometimes bad memory causes freeze ups when u do certain actions(keeps accesing the same part of the bad memory). also upgrade to office 2k w/ access2k
  15. megavolt121

    creating reports

    The message says #Error. I've checked the Statements and I'm using: =IIf([Stage]=0,&quot;No&quot;,&quot;Yes&quot;) The appropriate field for data is named Stage and still exists. when using the form and clicking on the radio buttons, I'll still get values of 0 or -1 in the Stage field.
  16. megavolt121

    creating reports

    Cosmo, Wildhare, all I've tried the code that cosmo gave me up in the 2nd post. I have four different fields: Stage Stage(1) Stage(2) Stage(3) Now this code gives me a #Error for stage, Stage(2) and Stage(3)... but for some reason Stage(1) works fine. I made sure the code was right and that...
  17. megavolt121

    creating reports

    Ok question about this: =IIf([rdoField1] = 0,&quot;No&quot;,&quot;Yes&quot;) Please bear w/ me since Access is realy new to me. IIf - does this part create an If-Then statment?(i'm trying to relate to C++/Java) [rdoField1] - field where my data is. =0 - the if part, at which point it'll print...
  18. megavolt121

    creating reports

    I'm trying to create a report in which a few of the fields are numerical values of 0 or -1.(They are set by radio buttons in the forms). I'd like these fields to print No and yes respectively instead of 0 and -1 when I have a report generated. How do i do this?

Part and Inventory Search

Back
Top