Search results

Anyone care to share some songs or contribute to a music thread? Currently listening to this gem - not endorsing, but somehow came across it tonight, and I was introduced to it by a fellow coworker at my first job.. Out on the lumberyard mud field with a chainsaw and putting together all of the...

Hmm.. I was expecting to see a bit more. I'm not sure what else I could suggest then. Here is mine for 16.0 I thought yours would maybe display some show/hide object or default settings, etc..

No - Only need to see settings - click on the settings folder on the left and take a screenshot of that. Or take everything after 'settings' out of the path.

That is Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Settings\CommandBars if you look in the file path address bar up top. How about just: Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Settings And also ------...

Not suggesting you change anything just curious of the registry values if you want to share a screenshot of them. How does this registry path look: Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Access\Settings?

That's a good question. My registry for 365 access looks similar to the image of your PC. Maybe share images of the settings registry values as well and we can see if something sticks out. I just thought I would throw that out there as you mentioned only having those 2 toolbar options...

If not mentioned yet, maybe try checking some of your registry settings. Should be something like: HKEY_CURRENT_USER\software\microsoft\office\11.0\access\settings\commandbars

If it is just least and favorite color and you were storing the ID with peoples names, then you could have: SELECT tblPeopleNames.full_name, tblColors1.Color as 'Favorite Color', tblColors2.Color as 'Least Favorite Color' FROM tblPeopleNames LEFT JOIN tblColors tblColors1 on tblColors1.color_id...

Can you post table relationship diagram? if you don't have relationships setup already - no problem - just drag all the tables into the relationship view, expand all tables so we can see necessary fields, and then post the screen shot?

Here is my relationship diagram right now. TblTemp is loaded with a no header transferspreadsheet, parsed to tblImportPlan - and then I move to tblPlan & tblPlanDetails. Model_pn = assembled part/kit part_number = components that make up the assembled part, with no overlap between 1 part on...

Hey AWF, Happy Monday. I'm trying to draft up a decent way to put together an inventory calculation for a new database that we are implementing. This is a pretty simple supply/demand model - I would say more similar to receiving a sales forecast, purchasing towards it, and receiving it - that is...

do i just run a timer on the screen? I mean, me personally - i do not know best practice here. and i dont know if there necessarly is ‘one’ i mean sure, i could put whatever query or data behind the form on a timer refresh.. But if someone has a live view of a screen that they need to plan...

There is some good stuff in this thread. I will say - I'm in this same position. I'm a DBA of 20 of the big babies, and IT wanted them out of the house +2 years ago. How many Access DB's do we have? >1000. How many access db people? 1. In reality many of the >1000 can be replaced with jobs on...

You are spot on @plog - I was going to say you might be, but figured I'd go ahead and step through it. Thank you for your help. You've changed my perspective here - I'm over here wanting to protect the precious data we have parsed, imported and cleaned, Thy Lord forbid something should...

Ultimately this is what my order table would look like as I imported the original schedule that was sent out, and then processed the #2 & 3 schedule revisions sent out afterwards. I added an additional 'QtyRequired' column to indicate order no longer needed as it has changed. This could also be...

Hello AWF, Scratching my head with this one. We receive a scheduling file that we import into our database to build the kits on the order, and sometimes the next schedule update will be a revision that modifies the orders. The problem is when there are deviations requested to the part kits, and...

I missed this. LastRow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row Or LastRow = xlWorksheet.Cells(Rows.Count, 1).End(xlUp).Row

No promises, but try: LastRow = Cells(Rows.Count, 1).End(-4162).Row I had do something similar but it was for finding the last column. I had to use .End(-4159).Column Apparently with late binding the xlUP doesn't mean the same versus if you were using early binding and had Microsoft Excel...

Thank you for the insight. It does sound like there are more advantages to early binding as you pointed out, but yes in this case, I have no choice in late binding - with the advantage of being... It works!! Lol.

This is great. I missed the intellisense once I switched to late binding.. Are you saying the path should just be called like below? This was my first time converting late to early binding. Mostly I have just converted api calls to be compliant with 32 & 64 bit machines. And I have many...