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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bobleonard

  1. bobleonard

    Missing over 20% of Dell SSD drive

    Thanks for all the info. FYI the partition information locates the missing GIB. I can't believe I forgot about partitions. In need to quit programming and start reading some of these Forums. BobL
  2. bobleonard

    Missing over 20% of Dell SSD drive

    Thanks for the information. As I understand it: The 128-GB from Dell is actually 119.2-GIB. Windows is reporting 101-GIB. Still, 18-GIB short. Less than I thought but still missing about 1/5 of what I thought I purchased??? BobL
  3. bobleonard

    Missing over 20% of Dell SSD drive

    I just got a Dell Venue 11 tablet. The specification is 4 GB DDR3 memory and 128 GB eMMC Solid State Storage. My C-drive is 101GB. What happen to 27GB? My searching indicates that a small amount may be used for some OS functions but over 20 % seems extremely excessive. The truth is: I...
  4. bobleonard

    Saving Changes to a Control's Properties

    Hi, I'm making some changes to a control's properties. I do this in the Detail.Format event. The changes work fine but I would like to save them. I've tried: DoCmd.RunCommand acCmdSave after I make the changes but this doesn't take. Also, (from reading posts) I've tried: DoCmd.Close...
  5. bobleonard

    Processing on Events not going like I think it should

    The change to: Me!A0.value = Str(mylonga) made no difference in open report event or the format report event. In the open report event, I got error-2448, cannot access the variable. It works with the code in the format-event on print-preview. Why? Mine is not to reason why. Consider the...
  6. bobleonard

    Code for Unbound text not working in Report Open Event

    Sorry, I moved this question to Access VBA programming. Bob
  7. bobleonard

    Processing on Events not going like I think it should

    Hi, I'm probably this is my first report that is just coding. Hopefully someone can enlighten me as to where I went wrong. I first put the code "Me.A0.value = Str(mylonga)" in the open report event. I get the error: cannot assign a value to this variable. Debug shows I'm reading the correct...
  8. bobleonard

    Code for Unbound text not working in Report Open Event

    Hi, I'm probably doing something dumb here but maybe someone can enlighten me. I first put the code "Me.A0.value = Str(mylonga)" in the open report event. I get the error: cannot assign a value to this variable. Debug shows I'm reading the correct data in the table. Next, I move the code to...
  9. bobleonard

    Report on multiple items with multiple-lines/item....I clueless

    More like: RecID SomeFieldA SomeOtherfieldB ThirdField 4thField -------------------------------------------------------- 123 FieldAinfo FieldBdata Field3info Field4 234 FieldAinfo...
  10. bobleonard

    Report on multiple items with multiple-lines/item....I clueless

    Almost exactly so. I've been thinking about looking at a Word merge???? It's been a long time since I've done one, but it seems to me, what I did was very close?? BL
  11. bobleonard

    Report on multiple items with multiple-lines/item....I clueless

    Hi, Hopefully, someone can point me to some info/posts where I can write multiple lines for each record in a table. I would appreciate it. The report would have 6 lines per item. I'm guessing 4-items per page. Since the multiple item format only allows one item per line, I can't (?) use it...
  12. bobleonard

    My code always edits first record??

    This code, though it moves to the record I input, it always edits record number 1. The ID field is an auto-number field. I put this code together from examples but I don't know what I'm doing wrong. Thanks for any input. I took out the 'useful' code because it doesn't matter for 'Edit'...
  13. bobleonard

    How to debug the DoCmd.OpenReport options

    Hi, I found the problem. I had set this report to run as the result of a Query. When I added the code to print a single record, I deleted the Query as a data source (my mistake). I went back and pointed the data source to the table and all is well. My Bad! Thanks. BL
  14. bobleonard

    How to debug the DoCmd.OpenReport options

    I tried the Me.ID and got the same results in the preview. All fields were: #Name? Thanks, even though
  15. bobleonard

    How to debug the DoCmd.OpenReport options

    I got the following code off a tek-tip post: When I run it, all the fields come up '#Name?' I assume the query is bad, But it is: ID = 1 for first record. Any suggestions? Private Sub Command226_Click() Dim strWhere As String If Me.Dirty Then 'Save any edits. Me.Dirty = False...

Part and Inventory Search

Back
Top