Search results

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

We do not unfortunately. Our IT has a lot of systems locked down and limit 'generic' workstations to be some version of office 2013, while all AD users are on semi-annual enterprise releases. I've found some workstations that havent been updated since 2009. Usually things are not too much of an...

Wow @MajP . Well, I don't know what I was doing on Friday. My first error was on the function below, that originally was 'As Worksheet', and I thought I had changed all dim xlapp to be object and setting as create.object("excel.application") object instead of excel.application. Maybe I missed...

Hey hey, Sup AWF. I was wondering if it was possible to modify this example access file to be late binding vs early binding. I modified the sample file quite a bit to get everything that i need -- but now that I have a good solution in place, I would also like to change this file from early...

The Me.RecordSource = strSQL would show you whatever the SQL below returns, and then your controls/form fields will get the data from Form_B's recordsource. strSQL = "SELECT P.CPS_REP_ID, P.CPS_FIRST_NAME, P.CPS_LAST_NAME, P.CURRENT_MEMBER, P.DATE_ADDED, " & _ "P.DATE_REMOVED...

Do you need to make it the forms recordsource, and not recordset? It looks like you are loading a recordset but doing what with it? If form fields are bound to the recordset, I would think it would need to be Me.RecordSource = strSql, but I would probably move the code to the frm_CPS_EDIT load...