Search results

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...

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...

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...

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...

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--------...

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)...

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...

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...

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...

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...

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...

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...

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...

[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...

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...

Hello All, Another question for the Access Gurus. This is weird problem that I've never seen before and I can't figure out how to fix it. My old machine died so I now have a new Windows 10 machine where I am running Access 2016. The problem is that the size of the boxes for each table name...

CJ_London, Thanks for the sample, I haven't had a chance to try it yet, I'll reply back when I get a chance to test it. Take Care, accvbalearner

mdlueck, Yes that is correct. Form B should be able to set focus back to Form A as part of its Load event. I can't figure out the correct VBA code syntax to set the focus back to Form A after Form B opens. I am using the Docmd.OpenForm on the OnLostFocus Event in Form A to Open Form B. I...

CJ_London, Ok, sorry about that. Going back that way, might work but I don't have enough room on a screen for a User with <1280. I can't figure out how to do that though, because a User will need to see the info while they are entering data. Thanks for the idea though! Take Care...

md_lueck, Nice to hear from you again, you were a great help to me on another problem a while back I believe. I've followed your two links but they are both referring to a Subform. I've tried using the Me!Parent at the beginning of the statement, but it just gives me an error and prompts be...