Search results

oh wow thank you so much that is just what I needed!

Hello, I have a split database on a shared network drive. I was wondering on what the best way to distribute the front ends to everyone would be. I can simply send it to each user in an email to use but then is there a way to push updated versions of the front end directly to their copies...

Could you elaborate on this? what would the code look like then? For now, there wont be more than 10 admins so I think itll work how it is. But I would like to know out of curiosity, and for future reference if possible. I'm always interested in making my code more efficient. Thanks!

Thanks for all of the responses! I actually thought it would be easiest to add a field "Admin" to my "Names" table and use a recordset to iterate through all of the ID's in the table who are also an admin. I appreciate all the help. Here's the implementation, if anyone is interested: Function...

Hello, I have a list of different user ids that are admins for my database. I am trying to write code to validate a button so only amins can successfully enter a form. the way I have them defined is: dim admin1 as string dim admin2 as string dim admin3 as stringand so on.. I was wondering if...

Hello, All I am trying to do is copy a pdf from a shared network onto the users desktop and then open it. after googling around, this is what I came up with: My.Computer.Network.DownloadFile(FilePath, "C:\Users\" & GetUserName & "\Desktop\FileName") Application.FollowHyperlink...

Yeah I was just doing that to test if it was working or not. When I distribute it to everyone officially I plan to do it via email with an attachment of the front end for them to install locally.

Yeah it turns out that the users weren't added to the permissions of the shared drive folder. I had to go in and manually add them and give them write access. Once I did that then one user who tested it for me was actually able to just open the front end from the drive and add/modify data...

Hello, I have been developing an .accdb database for a while now and it's ready to be distributed to other users. I have split it into its front and back ends, and it is located on a shared network drive for everyone to use. I changed my front end to .accde to avoid access to code/design...

Ive found that for some reason in the FE, when I am in the design view for a query for example, the relationships do appear. However when I actually go to the Design tab and select relationships, all of the tables appear but their relationships have vanished also. I think they still exist...

I tried that and only 5 of the 30+ tables appear. Evidently those are the ones I have added from inside the back end file. I am not sure why I cannot view all of the original relationships.

Hello, I have been working on a database for quite some time now. A few months back I decided to split the database and now im running into an issue. I have about 30+ tables in the back end and I now learned that I have to add more. When I open the back end file, I see all of the tables there...

Ive just noticed one thing that you may be able to further help me with, there are two bounded controls on the form that still aren't getting updated with the rest of the form. when I manually click on new items in the FormA crList they update fine but when I try to do it with vba it doesn't...

AWESOME it works. at first I got an error but for future reference I had to make sure FormB was bounded as well; despite none of the controls being bounded.. Thank you very much!!!

I have made the sub public and changed the code where I call it to: Call Forms.FormA.crList.AfterUpdate Now I am receiving an "Object doesn't support this property or method" error.

hello, I have a bounded formA controlled by a listbox. Everytime I select an item in the list box the after update event is called and I use the following code to update to the selected record: DoCmd.SearchForRecord , "", acFirst, "[Design_Change_Item_ID] = " & Me.FormAListbox then I just...

Hello, In my database, it isn't a requirement, but I think it would be a cool addition if the user had the option to upload attachments. I have added a new attachment field in my table, but seem to have trouble populating it within a form. In the table datasheet view, I see the...

Hi, I am trying to compare differences between two queries. In my form, I have 2 multi select list boxes displaying similar information and I think it would be ideal to be able to press a button and then the list boxes will only select items that don't exist in the other. I was thinking...

For me, the horizontal bar only appears when there is only one column width set and its larger than the listbox itself. That doesn't work for me because I have 6 columns I want to display. If there is no other way I suppose I will create a subform. Thank you guys for the replies

making the columns wider doesn't make any difference for me, unfortunately.