Recent content by accvbalearner

  1. A

    MS Access didn't update XX Records due to lock violations

    Hello All, Hope someone has had a similar issue to the one that I am having. Using: SQL, VBA in Access, Sharepoint List What I'm trying to do: Update a record in a SQL table with updated data from a Sharepoint List using a button in a form in MS Access. What is happening: When I run the...
  2. A

    VBA For Each Loop Help

    To theDBguy Sorry, I think I replied to myself instead of the one of the folks trying to help me! Hope the info below is helpful. Take Care, accvbalearner Thanks for all of your comments, and I guess I need to clear up the muddy water! I was in a rush at the time, I'll try to be better with...
  3. A

    VBA For Each Loop Help

    Hello All, Thanks for all of your comments, and I guess I need to clear up the muddy water! I was in a rush at the time, I'll try to be better with the explanation. This is part of database that is accumulating/tracking progress of a set of tasks over many different projects. At present, I...
  4. A

    VBA For Each Loop Help

    Hello All, I'm hoping someone out there can point me in the right direction. I don't know exactly what question to ask, because I don't know the correct terminology to use......I Think! So I will explain a little bit and may be someone can figure out why I mean! Ok, I have an Access Form...
  5. A

    Form using multicolumn multiselect listbox to add rows to a table

    theDBguy, Thanks for your quick reply. I have the Column() statements remarked out because they work, but not correctly. The multicolumn, multiselect listbox has 5 columns, basically name, rank, serial number, type stuff like below: Name---------- Rank------------ EmpNbr------BdgNbr--------...
  6. A

    Form using multicolumn multiselect listbox to add rows to a table

    Hello All, I need some help and I'm sure there is a someone out there who know exactly how to solve my issue! I have an Access form, in the form the user enters or picks a date, chooses a project from a combobox and then a report from a combobox. The first two boxes (date and project)...
  7. A

    Record Locks between SQL Linked Table and Access Form

    Thanks for the quick reply, I am sure that is what is happening, but I just don't know how to trace it. I'm trying to figure out how to show you the code, what should I get for you to review? If the below info isn't what you need, just let me know where to go.... Here is what I think you...
  8. A

    Record Locks between SQL Linked Table and Access Form

    Hello All, hope there is someone out there who has had a similar issue and can let me know where I went wrong! I have an Access front end using linked tables through a DSN connection to SQL Tables. I have created a form for entering data into a table. The form seems to work great, but after...
  9. A

    Separate Time from Date in a Report Textbox

    June7, Thanks for your reply and idea. I tried to place a value into the Tag property in design view of the [ST] Text box and got another Run-Time 13 error. This time is stopped on ctl.Fontsize = ctl.Tag I tried three different values in the Tag Property a spacebar - got a Run Time...
  10. A

    Separate Time from Date in a Report Textbox

    theDBguy, I tried your idea from another recommendation on this forum but it didn't work. Can you give me an idea on how to make it work? Here is what I did: In the property sheet in the Data Tab Control Source I entered: Format([ST],"hh:nn"). When I run the report I get a Run-time error...
  11. A

    Separate Time from Date in a Report Textbox

    Hello All, Need assistance or an idea on how to proceed. Here is my issue: I have a report in Access that prints four columns of time along with names as such. Its a timesheet, some names are big, some are small. In short I have added the code below to the Detail Section On Print Event...
  12. A

    Access Query w/Access Table & SQL Table VERY SLOW

    ridders, Thanks for your quick reply. First Answer: I'm replicating because the data needs to be together to export to Excel for a client to review, so I need a piece (HOPD) of data from the SQL table added to it in order to send. The time problem that I described is even worse when I try...
  13. A

    Access Query w/Access Table & SQL Table VERY SLOW

    Hello out there, need some advice on a query that has been giving me fits. I have a SQL Backend and an Access 2016 (*.accdb) Front End. I have a table in SQL with 24 rows. I have a table in Access with a few thousand rows. There are two common fields in both tables [HOP1] & [HOPD], both...
  14. A

    Navigation Pane Display Problem

    [SOLVED]: Re: Navigation Pane Display Problem Mr. Conrad, Thanks! The link you provided: http://answers.microsoft.com/en-us/o...-5ac099d2ba50/ worked perfectly, it is the exact problem that I was having. I ended up changing my display properties to 1920 x 1080, set the slider in Display...
  15. A

    Navigation Pane Display Problem

    Snueberg, Thanks for the reply. I should have put in more info in the original post. I have already tried the right click view options and also resetting fonts in control panel and checked the same database on an office 2013 machine, its fine there just not in 2016. If you look at the...
See more
Top Bottom