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: *

  1. TelcoBT

    Flickering field (ntext 16)

    A long shot this one, but does the database compact and repair OK? I ask because I read about a 'DECOMPILE' option that I've used a few times that suggests that not all compiled code is removed in certain circumstances and using it did solve a couple of odd problems for me. I'm certain I read...
  2. TelcoBT

    Flickering field (ntext 16)

    If all fields flickering then I would guess that somewhere you have refresh/requeries cascading - I used to get this on a complex subform I inherited. The bad news is that you may have to put in break points and step through code, I did and even then I also found refreshes in the event...
  3. TelcoBT

    Trouble adding new records in child form

    If I understand you correctly, Yes, there are a few ways but being a programmer they are all in Code depending upon how I open the form. *********** If you use doCmd a) In your button to pop up the frmTestScenarios add an OpenArgs (I think that is the name - I'm not at my Access PC so can't...
  4. TelcoBT

    Query using Dsum challenge for the experts

    I think you have made an error in keying, Note the Sum is MyValues_1 not MyValues in the original SELECT MyValues.Name, MyValues.Value, Sum(MyValues_1.Value) AS Total FROM MyValues INNER JOIN MyValues AS MyValues_1 ON MyValues.Name = MyValues_1.Name GROUP BY MyValues.Name, MyValues.Value; I...
  5. TelcoBT

    Access to Excel Export

    Not sure if this maybe a registry issue, my DB only exports 32K records before complaining and aborting the export - try Microsoft sites.
  6. TelcoBT

    Extract data from a record in a table

    It may be possible to use SQL, but I would go for code and iterate through the table records and for each record iterate through the fields. One possible design is shown below NB The syntax below is CERTAINLY incorrect, as when coding I use the IDE to the full and let it pick up my typos and...
  7. TelcoBT

    Browsing File Paths

    I am assuming that 'BrowseForFile' is a function of yours, and it is there that the 'browse window' should appear? If so the code for BrowseForFile would seem to be the problem, not this code.
  8. TelcoBT

    Modifying Data in Access then Exporting to CSV file

    I had so much help from people in here when I first started Access that it's good to feel I contributed for a change! Good luck with the export.
  9. TelcoBT

    Sub From Totals

    One way is,I think, a matter of knowing the hierarchy of the sub form fields then setting the 'total field' to the sum of them, eg =[forms]![myParentForm]![subForm1]!subTotalField + [forms]![myParentForm]![subForm2]!subTotalField (my syntax above is probably not accurate, as Access isn't my...
  10. TelcoBT

    Modifying Data in Access then Exporting to CSV file

    If you have imported the CSV file, then you have it in a table, however I would then be looking at a Query to create a new table from your imported table, manipulating the data in the process. If you read up on queries and play around in the 'Query by Example' grids that appear if you select...
  11. TelcoBT

    Function getting error when field empty

    I think you need to return a variant from your function, as otherwise it is expecting a date variable.
  12. TelcoBT

    'Import Wizard' in Excel

    Simple export into Excel wouldn't be a problem, where a new excel file is created and the data 'streamed in by Access', but exporting to a specified region, would, I think,need VBA , as I think you would need to point to each cell in the region into which you want to add the information.
  13. TelcoBT

    Duplicating records using access 2002 VBA

    I'm not at my Access PC so cannot look up the syntax of DateAdd, and not knowing how you intend to record the booking period (eg fromDate to toDate or fromDate for x days) I would look at a loop using the dateAdd function to generate the booking date, and add a new records on each iteration of...
  14. TelcoBT

    Is this easy?

    No, but if this is claimed to do it, I would experiment with values other than 0 in the TwainSelect brackets.
  15. TelcoBT

    Access database conversion losing code

    Assuming that you are not setting the 'has module' properties of the forms to 'No', then suspect corruption of the database. Take a copy then look at the following site for help - maybe use 'decompile'and see if that helps. The link below is useful...
  16. TelcoBT

    Printing label for current record in form

    You need to enclose text within single quotes as "Company=' " & Me.Company & "'"
  17. TelcoBT

    error with multiple users

    I found comments on the site below, http://www.adopenstatic.com/faq/80040e21.asp and also found the one below, although this is for an ASP front end, where the data input is less restricted. "Right, I just solved the problem. The length of the field in the database was too short.&quot...
  18. TelcoBT

    error with multiple users

    I'm still checking, but one possibility is that you need to upgrade you MDAC, as this is one of the MS explanations of this message. Microsoft OLE DB Provider for ODBC Drivers error '80040e21' The request properties can not be supported by this ODBC Driver. If I find anything more relevant...
  19. TelcoBT

    Query as control source for text box question

    I'm not in front of my Access PC so some of my terminology may be a bit out, but if you look at the ALL tab of your properties, for any Text box you will have it's name property and below it should be the name of any bound field. IF you have a record source set for the form, you shouldn't need...
  20. TelcoBT

    Keep Pop-Up Data Entry Form Blank

    You need to open the sub form using acNewRecord as a parameter, using DoCmd if I recall correctly. (I'm not on my Access development PC so I can't lookup the correct syntax)

Part and Inventory Search

Back
Top