Search results

Correct, Sorry I meant the .mdb(FE) file.

Thanks SOS! I'll give that a shot! So the shortcut is another way to make the database more secure correct? So when deploying the FE's to user's computers I place the .mdw file on c: and let's just say the shortcut on the desktop? Can it be in the same folder?

So on the user-level security wizard I selected the "I want make this my default workgroup information file". I looked at where the default .mdw was placed and it was directly in my folder, so there was my problem. SOS, I tried using the second option which is the shortcut but I have a couple...

Security Help/Questions after Deployment! Hi everyone, Ok, so I created a copy of a non-secure database that I was working on and placed it in another folder on the same shared drive and renamed it. With the copied database I went ahead and applied security and everything is working fine. Now...

:) Thanks!

chacha :) haha , i think your going about getting help all wrong. Patience! And like I said before, you might get more help starting a new thread so people will see it!

I'm just trying to get a basic understanding of how the security works, I was just giving a background to what they want. I know splitting is the best way. Just wanted to see if there were other options as well. Thanks jzwp22! I'll play with it. I couldn't have gotten this far without your help!

Hi everyone!, I have tried searching and I'm close to a solution but I need some help with how to do it. I would greatly appreciate some advise and teaching on this subject since I'm partially a noob to Access. I know it's not common practice to print from a form but you tell me what would be...

Here is my problem, as of right now my supervisor said to keep it simple and account for only one user using the database at a time. I don't want to deploy FE's to each computer because there are only a select few people that will use the database and even then I don't know how much they will...

Sorry for the noob question. Listboxes don't have a recordsource only a rowsource? When creating the report how do i get the information displayed? Do i add a listbox and don't select any settings and input the rowsource from the listbox in my form? In my Search Form the record source is blank...

Thanks so much for all your help guys! I wanted to get some opinions on security and permissions. This database needs user-level security and log-in. Is the User-Level Security Wizard the simpliest and most effect way to set up security for this database? I have been playing around with and...

I have a similar question: How can I print out only the contents of the table on a separate sheet? How can I print the entire list if the table is longer than the form?

I just used this form and it works great! Thanks Oldsoftboss! Make sure you read through the entire code again and replace the strings with your DB info, (frmSales with the form that you want to use.) That's all I did.

Hi agehoops! I have been reading through your search function thread and was wondering if you could assist me in few questions I had? Thanks so much!

But if the user is entering data I don't want them to jump over to the Reports tab to be able to print, and have to select which record they want printed. It would be easier for them to just print the current form they were entering and move on to the next form.

Hi everyone, So I have a Mainform without page/form headers and footers and a Subform. The Subform is in datasheet view which works well since it's a table were users can add revisions so the table can grow. Everything prints just fine but I run into problems when the datasheet becomes larger...

Thanks jzwp22! Sorry, do you want me throw the other table in there? So I have my form set up and working great! My next step is to be able to search for specific data that is in the database. What you guys recommend as a good starting point? I'm researching search forms now. Thanks so much...

My database has change a little from the original. I have attached the subform by itself. I want the sequence number to auto increment when a new revision is added. Thanks so much for your time.

I just want one of the fields to act like an autonumber field. Is this the easiest way to do that. I don't need these values to be stored or anything. So how can I increment a field without using autonumber, since there can't be two autonumber fields in a table.

Do you think I could get some more detail on how to do that? Sorry!