Search results

Hi Darrell, So the yellow Text boxes are supposed to move based on the code in the 'Compress Charts' Sub which runs from the 'Re-Organise All Gantt Charts' button. Which line(s) select the text boxes & moves them?

Thanks again, I don't mind what I need to do, code or Link Table Manager (LTM), I just want to know how to best ensure the BE is connected correctly to the various FEs. I would have thought if I used the LTM to check the connection from the Users PC to the Networkdrive BE, I should be OK as...

Thanks Pat, Good point though I did use the Link Table Manager wizard to browse to the BE. It also may have not auto linked as I had just updated to Windows 7 & it had to install extra software to deal with the issue. Is there a way I check that an UNC path has been used OR does the Link...

Thanks, I followed those instructions & I did find that I needed to relink the FE to the BE when I copied & pasted the FE file from the Network drive to another PC. A test confirmed that changes on one PC updated the BE & that change was then available on the second PC. Appreciate your...

Thanks CJ London for the clear & complete response. So when I save a copy of the FE onto the Users PC, I'll need to link the objects to the BE on the Network drive in order for the updates to happen for each user concurrently. Can you confirm pls? Thanks

Thanks for that, So the steps to do this would be; Save the full (FE & BE) database file to the Network Drive (LAN) Also Save the full (FE & BE) database file to the Users PC Split the DB on the Users PC into FE & BE Use boblarsons software to link the Users FE & the Network BE Is that what...

Ok, thanks. I'll have a read, is this code connecting each Users FE through the LAN to the Network FE? Is your software doing the same as linking the tables from the FE on the Users PC to the BE on the LAN? If I'm not correct, could you explain the connections that the software is...

Just read this & have a question for Gemma the Husky. When you say "give each user an individual copy of the front end", do you mean go to the Databse file FE which is filed on the Local Area Network (Office Network) & create a Shortcut onto their Desktop? I hope so because that's what I've...

This may help you understand how your data could be better organized. Have a look at the attached database file. I have created 2 tables as I suggested above in Excel & imported them into Access. I then created a relationship between the 2 tables on the ID field. Have a look at how the...

Have a read of the link as it shows a similar example. The way to think about Normalising at the beginning is to write out the field names & what has a One to One or a One to Many relationship. Your spreadsheet has more than one year for the 'Partner_Europe_Name' Therefore the ONE...

Hi Armine, So the Access Import process is working correctly & your issue is that it imports the 'NA's that are already on the source spreadsheet & these will not work in calcs? Is that correct? Sounds like you know about the table field datatypes as you've chosen the Number datatype for...

I can only make assumptions & give general advice without access to the actual file. It could be there are variables used in the code that are causing the inconsistencies, but I need the full code & preferably the file uploaded so I can try it out.

Hi Darrell, Have you tried stepping (F8) through the code to see what's happening with each line? You should be able to find the line(s) that are making these changes. Otherwise, I would need the file to see this for myself using both 2007 & 2010. Hth

Hi Again, Here's a quick mockup for what I think you're after. Let me know if this is what you wanted. Cheers

Hi VMoney, Can you advise the version of Office this was created in & where you get the error & what the error is? Just to confirm, you want the user to open a Form that has a Combo Box Drop Down Menu with these 4 items. As they click on one of the items in the selection, that report is...

Hi Armine, Are you using the Access Import Wizard to import data from an Excel spreadsheet or using a Macro? Can you post an example of the data you are trying to upload & tell us the version of Office you're using. Thanks

I want to have another try. Can you post your Array data (Source data that the code is working on) in an Excel file? Also, your code isn't in a Sub or Function. Can you post the full code including the Function or Sub so I can exactly what you're doing. Something like the below...

Sorry, cInt would be the one in your list but as you need decimals, try cDbl. I also found that the "LN' function is available as per below; Application.WorksheetFunction.Ln ... As you've probably guessed, I'm working through this with you so I'm learning as well. Let me know how you go.

Hi John64, You may need to convert the Variant to an Integer. Try something like the below before you do the DeclineV - 1 line. I would say as the compiler doesn't recognise DeclineV as an Integer, you can't subtract 1 from it. Public Sub Demo() Dim Intval as Integer Dim VariantVal As...

Have a look at this link; 'http://www.office-archive.com/4-excel/ec0f28c4daafc36b.htm It shows how to use an array with VBA. Hth