Search results

Hi, this will need to be done every period with new data. So next Period i'll be comparing Jan with Feb Thanks

Hi all I have 2 identical tables with different data. They have both been imported from excel as I couldn’t do this in excel. Table 1 has data from Dec Table 2 has data from Jan Fields are: EENo, Code, Date (Fixed either Dec or Jan), Value Table 1 will have Decembers Value...

Hi I have a report that prints receipts for membership. It currently prints on A4 as this service was not to be used. I have now been informed more and more people are after the receipts so i need to change this to an A5 letter. However within my report, when i go into Page Setup, i cannot see...

Thanks all Is there a hard and fast rule regarding getting all forms the same size? I have looked at Form Width, Header and Detail Hight, Grid X and Y, but some are still bigger than others Thanks again for all your help everyone. I have learnt so much in 2.5 yrs i have been on here.

I tried this but get "the expression you entered refers to an object that is closed or doesn't exist" Any idea's? EDIT: It does work, needs to be mysubform.sourceobject = Thanks for your help

Thanks That's what I have at the moment but want to chAnge the look. See all the forms are different sizes and I've tried to replicate the sizes of each but still get some form a few cm's up or down. And this doesn't look very professional. Hence looking at sunforms so atleast all forms will...

Thanks RuralGuy and Uncle Gizmo, i didn't know. See i always use the subform wizard. Any tips on how to get started? Thanks as always

Thanks but i thought subforms needs to haver child/parent relationships? My setup above are not related. I just want to be able to click on any command button and have that form appear in the middle.

I currently have this: Where the user would select the required module. This would then bring up the selected form and an exit option within the form to get back to the above. However i would like to try something like this: So the user would select the required form and this would appear...

After your opinion here. Say i send the user a packaged db and say 6 months down the line, they find an issue with something (anything). Usually i would request the DB back, open it up, replicate the issue and then try to fix it. How would one deal with this if it's packaged?

Thanks But is it secure?

Hi Using the Access 2007 Developer Extensions and Runtime, i have deployed one of my 2007 db. Just a couple of questions: 1. Once the users 'installs' the package, is the DB fairly secure? I mean could the users shift and open to get to the backend? I did try myself and couldn't shift open but...

Thanks I did think of that but i don't have 2007 or 2010 (can't afford it at the mo)

Hi Can someone please help? I have written some db's in Access 2003 and they work really well. Some of the users now have either 2007 or 2010 on their machines, meaning my 03 DB doesn't work very well on their systems. Is there a way to deploy/include Access 2003 within my DB, so that each...

Thanks all. Some of the DB creation involves import from excel, so they will have to give me the data. I'll get something in writing from them like vbaInet has suggested. Thanks again

Cheers, Yes it is a real shame. I will be looking this up on google but the whole act is HUGE... Thanks for the advise.

Not sure if this has been answered. I'm doing some work for various clubs and stuff, and in the process of creating their DB - i have some of their Data (names, address, phone number - that's all) What should i do? At the moment i have emails from them saying it is OK for me to hold their data...

Anyone pretty please?

Hi I recently secured my DB by using the standard access workgroup security thing. So i have a link, the db and a workgroup security file. (The DB and Security.MDW are in the same location , with the link on the desktop) The issue i now have is that none of my ODBC (from Excel) are working. I...

One more question. Any tips on how to secure the BE? My FE has bespoke forms where userid and password needs to be entered, but this BE will just open up. I tried to put a password on it but then the linked tables wont work. Any tips please?