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 Chriss Miller 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: Dor100
  • Content: Threads
  • Order by date
  1. Dor100

    *Access Closes in Response to Record Navigation*

    I've been experiencing total Access shutdowns in response to routine record navigation with a form. They nearly always occur in response to: clicking the first-record navigation arrow in the lower left area of form view; clicking the first-record navigation button created on the form using the...
  2. Dor100

    Trouble with DoCmd.TransferText

    When I transfer text from a query to a .txt file through VBA or a Macro, date fields include the unwanted 00:00:00 time element, i.e., “01/18/2006 00:00:00.” I need to eliminate this so it doesn’t show up in merge docs that use the output for data. Why is it that when I export the same query...
  3. Dor100

    Trouble with Acc VBA automation of Word

    I'm using Acc XP VBA to open a Word mail merge doc which gets its data from an Excel spreadsheet. When the merge doc opens, I get a "Select Table" window requiring users to choose the data source in the Excel file. The two options are: WorkSheetName 'WorkSheetName' I'm trying to find a way...
  4. Dor100

    Open Word Merge Doc Without the Initial User Question Window

    Is there any way to set Word to open a merge doc without presenting the little window to the user which asks the following: "Opening this document will run the following SQL command: SELECT * FROM 'SOME DATA SOURCE' Data from your database will be placed in the document. Do you want to...
  5. Dor100

    Can't get started: ASP.NET page not working

    I've just started trying to learn ASP.NET with an online tutorial. I'm on a Novell client for Win 2k. The following simple code has been saved in Notepad as "firstdotnetpage.aspx": <html> <body bgcolor="yellow"> <center> <h2>Hello!</h2> <p><%Response.Write(now())%></p> </center> </body>...
  6. Dor100

    Completely New to PHP, Can't Seem to Get PHP to Run Yet

    Hi, I'm starting from scratch as a newbie to PHP, but not to writing code (extensive experience with Access VBA and SQL, and a bit of html with FrontPage). Right now I'm making my way through an online PHP tutorial. Apache 2.0.55 (Win 32) is loaded and running on the pc I'm using, which is a...
    • Dor100
    • Thread
    • Replies: 7
    • Forum: PHP
  7. Dor100

    Word Merge Doc Won't Work When Opened by Acc VBA

    Any Word experts here that know an answer to this?: thread705-1143474
  8. Dor100

    Word Merge Doc Won't Work When Opened Through Access VBA

    Problem: Have a Word XP merge doc using an Excel XP spreadsheet as data source. When you open the doc by itself, it opens as a merge doc and recognizes the data source (Me.ActiveWindow.Document.MailMerge.DataSource.Name = "Path-Plus-File Name"). When you open the same document from an Access...
  9. Dor100

    Back End Only Balloons In Size Through Use

    Someone told me about a problem with an Access back end (only) ballooning in size with normal use, such as from perhaps 800 KB to about 300 MB. I'm familiar with this kind of problem occurring with a front end, such as possibly through certain VBA code activity (which is why I'm posting this...
  10. Dor100

    Need VBA to convert Text to Speech for audible messages

    I've been searching Google to no avail so far. Are there any VBA commands in Acc XP by which I can cause text to be converted to speech in order to give audible messages to users? Or do people know of any free downloadable utilities for this?
  11. Dor100

    WeekDay function is malfunctioning

    The WeedDay function has begun to malfunction (Acc XP on Novell client for Win 2k). It is now producing a "Type mismatch" error despite having worked previously. When I use the IsDate function to confirm that the date argument is indeed a date, it returns True, e.g.: MsgBox...
  12. Dor100

    Changing form's query SQL and requerying through VBA not working

    I have a main form using a query as data source in Acc XP. Users have design permission on the query. Certain events or conditions determine the query's SQL through VBA. Why is it that when the SQL is changed through VBA, programmatically requerying the form is not working (I've also tried...
  13. Dor100

    DoCmd.Save acForm (...) will not work after adding control through VBA

    I'm opening a subform in design view from a procedure in another unrelated form and adding a combo box control through vba. Everything works fine until I try to save and close the subform. As soon as the code reaches the line to save it, I get the following error: "Microsoft Access cannot...
  14. Dor100

    Trying to add *Combo Box* through VBA instead of text-only

    Hi, I've been scouring the web to find the sql to add a combo box, or change a text box to a combo box. So far, I can add a text column in a vba module like so: CurrentDb.Execute "alter table TableName add EE text" But...I need the field to have combo box properties. I've also been trying to...
  15. Dor100

    What happened? Why is IsInGroup case-sensitive?

    What happened? Since when is the IsInGroup function case- sensitive? Here's the function: '''''''''''''''''''' Public Function IsInGroup(UsrName As String, GrpName As String) As Boolean 'Determines whether UsrName is a member of GrpName Dim grp As Group Dim IIG As Boolean Dim usr As User...
  16. Dor100

    What's your opinion about Dim Statement location?

    I'd be interested in hearing people's views on something. Does everyone feel that your Dim statements should generally appear at the beginning of your functions and subs, or do some feel it's ok and even beneficial to place them anywhere you like, especially if there's no trouble keeping track...
  17. Dor100

    Can't Open Temporary Querydef Object

    How do you open the results of a sql select statement without creating a permanent query object? Here's the basics of what I've been trying to do in a VBA module: -------------------------------------- Dim Q as querydef Set Q = CurrentDb.CreateQueryDef("", "select * from Table order by...
  18. Dor100

    &quot;The Visual Basic for Applications project in the database is corrupt&quot;

    Ok, so what's going on? "The visual basic for applications project in the database is corrupt." I've researched this on Google and Microsoft.com, used JetComp.exe, done /decompile, tried just about every main menu item that might appear to have potential, and I cannot simply access the...
  19. Dor100

    Copy button won't activate unless form is frequently saved

    Ok - who turned out the lights? Or, rather - does anybody know what's going on here? All of a sudden, the Copy icon is no longer active when I'm designing forms unless I first save the form. So for instance, if I want to copy a control, I must first click the Save icon and then the Copy...
  20. Dor100

    Is there a way to determine the &quot;current&quot; field?

    Is there perhaps a "current" field just as there is a current record? I'm trying to use VBA to enable users to click a button and have check marks placed in every row for a specific field of a subform whose cell has the focus. So far I've come up dry after searching Help and the net. This...

Part and Inventory Search

Back
Top