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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: rasticle
  • Content: Threads
  • Order by date
  1. rasticle

    Opening IE w/ Google Maps

    Hi, I've look around and haven't found the answer I'm looking for. I'm trying to just open Google Maps in IE with a button in Access. I'm making some silly error that I can't seem to figure out. Just need a second set of eyes to maybe tell me what I'm doing wrong. Private Sub...
  2. rasticle

    Importing and mapping denormalized data

    Hi, This is probably easier than I'm making this out to be. If I have a data table that is denormalized and I want to import the data into a normalized database what steps do I take? What I have is very simple I have a table with facility and contact information. I want to seperate the data...
  3. rasticle

    VBA script to export excel to cvs

    I have the script running perfectly, but there is just one problem. In the event that someone enters a value with a comma in a cell it prints the csv file incorrectly. Here is the code: Public Sub WriteSheet(curSheet As Worksheet, pathstr As String, col As Long, row As Long) Dim txtStr As...
  4. rasticle

    Complex form filter

    I guess it is not that complicated, but I have a report that I am filtering by date. I have it working fine. But I want to add the option to allow the user to select by which date they filter the report. Right now I have a filter form with txtStartDate and txtEndDate and in the query (I just...
  5. rasticle

    Help with using Count()

    Hi, I am trying to create a summary report. The fields I want to summarize are in a Yes/No format. I have a query behind the report that pulls all of the fields that are Yes. It is set up like this... SELECT tblEnforcement.[103], tblEnforcement.[103CR], tblEnforcement.[6RK], * FROM...
  6. rasticle

    Can "Find and Replace" search values in invisible text boxes in forms?

    Can "Find and Replace" search values in invisible text boxes in forms? I did look at the FAQ's, if anyone knows what FAQ this is in please let me know! I am just trying to have the Find and Replace search through all text boxes on a form, even invisible text boxes. Thank you!
  7. rasticle

    Number Incrementation

    Hi, I have a textbox that I have hold the value for a case number. The textbox name is caseNum. I want it to be in this format "07KS2007" + caseNum for example 07KS2007123, where the case number is incremented up by 1 with every new case. I have a button that needs to be clicked to add the...
  8. rasticle

    linking subforms

    I will try to explain this the best I can. I am attempting to make a user interface for access using pages. This is new to me. So this is what I have done so far. I have 1 main form. On the main for I have the tabs set up with subforms in each of them. What I am trying to do is link all of...
  9. rasticle

    Primary key update

    Okay I don't know how to word this so it is not complicated. So I will give this my best shot, let me if it doesn't make any sense. I have 3 tables that are linked: tblFacility, tblEnforcement, and tblInspection. Each table uses the same value for a key. On the form I am working with, it is...
  10. rasticle

    Progamming dynamic error messages for input mask violations.

    I have a problem, I am making a form to enter dates. If I don't put in validation rules eventually the bad dates get into the database and to avoid that I am trying to create an error message that a user will understand. I have the code working for the default inputmask violation, but in the...
  11. rasticle

    Form Autosave Question

    Okay, this is probably a commonly asked question. I looked on the internet and through this forum and didn't find my answer. So I'm just going to ask. How do you get around a form autosaving data into the table it is bound to? Does anyone have a code sample to point me in the right direct...
  12. rasticle

    Problems with forms auto saving data

    I have created a database with Access. I don't know if this is a built in function or if I just need to change a property setting somewhere, but on all the forms when you enter data Access automatically starts saving the data, without having to use a save button. How do I remove this? Do I...
  13. rasticle

    real-time Clock

    Do any of you know how to display a live moving clock on an Access form? I know how to do the time stamp, but I just thought it would be cool to add in the "live" clock. I was just looking for an example or help in the right direction. Thanks!

Part and Inventory Search

Back
Top