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 strongm 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: binky
  • Order by date
  1. binky

    Missing Toolbar in Formula Editor

    I have 'lost' my toolbar that displays the close buttons in the Formula Editor. I am using CR10, any ideas how to get this toolbar back? I had undocked this toolbar and accidentally clicked the close button in the upper right hand corner. I know that I can use shortcut keys to do everything...
  2. binky

    Retreiving all the available database names from MySQL?

    WilliamUT, MySQL has the &quot;Show Databases&quot; command. Why don't you use that? HTH Binky ::-) ><>
  3. binky

    Parse Error &quot;unexpected $end&quot; Driving me bananas!

    luds, Once again sleipnir214 has it correct. You are missing your closing set of curly braces for your switch statement. HTH Binky ::-) ><>
  4. binky

    .mdb to mySQL

    I too am in the middle of converting from Access to MySQL. The easiest way I have found is... 1. Download and install MyODBC. 2. Create the empty database in MySQL 3. Create an ODBC to this empty database 4. Open your access db and choose -> file->export In the file dialog open file types...
  5. binky

    &quot;error in your SQL syntax&quot; - Using MySQL- Need help!

    sbayter Looking at the error I noticed that you only have one quote with Question 'EXPLAIN) VALUES ('Question, '3', 12345, NULL)' Maybe try 'Question' and see if that fixes the problem. Binky ::-) ><>
  6. binky

    Inserting to mySQL Strange problem????

    sanjdhiman, Another thought to try. Have you double checked the permissions of the username you are connection with to MySQL? And if you have changed the permissions have you reloaded MySQL? HTH Binky ::-) ><>
  7. binky

    Need some good PHP Calendar code

    Have you tried looking at some of the web mail programs. A lot of the ones I have looked at have calendars as well. HTH Binky ::-) ><>
  8. binky

    Simple POST problem I can not figure out

    HorsefaceBA, Try doing riffy's suggestion again but make sure you save the first page as 'yourname.php'. I changed your input type from hidden to text to see what value was in it, and that showed me that the first page with the form on it has to be .php. Is it already? You haven't mentioned...
  9. binky

    Inclusive Row Security on UDC values

    hawaii I know it's November now but what if you were to do this with code. Use the USERID system value with a table I/O to get the security level then depending on that security level over-ride the UDC lookup. Just a thought, or did you already figure this out? Binky ::-) ><>
  10. binky

    drilldown question

    Goha, The Crystal Report control that I use has a propertiy (WindowAllowDrillDown) that must be set to true. Do you have this property? Maybe it's the version of VB control you are using. Binky ::-) ><> Binky ::-) ><>
  11. binky

    Image in Report

    Dutchguy, I searched the Access help file for 'image' and found a control that is recommended for your situation, a 'bound object frame'. Try looking it up in help. Binky ::-) ><>
  12. binky

    About Microsoft Access 2000 security

    hallabad, I suggest you search through this forum for posts on Access Security. There are lots of great posts. As far as the VB connection string, it all depends on what kind of connection object you are using. Binky ::-) ><>
  13. binky

    Calendar style report help

    Sentra52, I have found this type of program on the Net before. Try searching for Access Calendar on Google.com and see what you get. Sorry I don't have the code anymore. HTH Binky ::-) ><>
  14. binky

    Date Functions

    Or maybe try this: DateAdd(&quot;yyyy&quot;,1,Val(Me![txtCurrentDateOriginal]) HTH Binky ::-) ><>
  15. binky

    Adding to a default value

    BigDav, Have you tried in your if statement... Me!Fee = Me!Fee + 5 If your Fee field is a text value then Val(Me!Fee) = Val(Me!Fee) + 5 Binky ::-) ><>
  16. binky

    Help debuging this opening form code

    DavL Have you tried your query expression without the single quotes around the OrderNumber in your query?? Binky ::-) ><>
  17. binky

    Locked File

    princeT We have had a similiar problem before. When Access is shared on a network server the clients are actually opening a copy of the original database. If the users don't have the proper permissions on the network folder to read, write, update and delete then they won't be able to use the...
  18. binky

    Code for Colors (VB)

    acct98, Yes and no. I'm not sure how much you would find looking for Access colors. BUT, try looking for HTML RGB values and you will probably get a ton. The thing I have done is open an image with the color I need in a 'Paint' style program. There is usually a tool (eye dropper) that gives...
  19. binky

    Date Formating

    tjisaacs, Have you tried the Value function? Value([collection date])+365 Value will return the numeric value of a text string. HTH Binky ::-) ><>
  20. binky

    Code for Colors (VB)

    acct98 Could you use MyObject.Color = RGB(255, 0, 0) instead? This way you can use any RGB color. Binky ::-) ><>

Part and Inventory Search

Back
Top