Search results

I have closed and reopened several times. I started this morning from a freshly booted local machine. I even read where all users have to be off front end and then close and reopen, compact & repair... I am running the only copy - no one else has access to this DB because it's in development...

In Access 2010 - I am getting an error when trying to copy forms/modules into my database from another that the database has been placed in a state by user "Admin" on machine 'my machine' and cannot be opened or updated. I saw some exchange with Bob Larson - where he said that this was because...

Is it possible to create a true treeview in Access 2010 like it is in VB.Net ? I have a table out of HR which gives each staffID and their Supervisors ID. I want to create a treeview picklist where the Supervisors and see subordinates and select documents from that subordinate. I could do...

I am Hungarian - 1/2 at least LOL! That is cool - thanks. I have been coding in VBA for YEARSSSSSSS and never even knew that. Very Cool!

You will not believe the stupid thing I did.... I left work and came back after everyone had gone, looked at the code, back through the variable declarations and I had made them doubles instead of string probably 4 months ago and never ever even thought to double check them. I also moved...

Hi all - I have a field in a table that is storing a number as text. In the table - the number is correct as 0365. However, on a Dlookup it comes up 365. I tried forcing a "0" in front and it still comes up 365. Is there a trick to this. It has to match on a query.

I guess I have looked at it so much (the back code vba) - and didn't do the forms... Thanks - I was going crazy with WHY and it was partial data deletions. 85% of the form was bound. We don't do bound forms - try to control EVERYTHING from VBA.

I have a Database where on 1 form the Cancel is deleting the first record in the TBL. It's a general Cancel code If Me.Dirty then ClearForm LockForm It resets the form for Editting/Adding content. Any Ideas?

I actually did go back and reqork the tables. Added a field for Active (Yes/No) so that if the selection is no longer applicable the Item ID does not change it's place in the list. Here is my code to re-select: If Not IsNull(DLookup("[EmailGroups]", "[NewStaffRequests]", "[ID] = " & myrec))...

The listboxes are fed through multiple tables because the tables can and will change over time. The strings are necessary because they feed into a function, get parsed and used in another context. I will try your sample. Thanks :)

I don't understand what your saying: Here are the values: Field 1 = "Egroup1, Egroup6, Egroup23" Field 3 = "DataGroup2, Datagroup23, Datagroup37, Datagroup38" Field 4 = "FolderGroup1, FolderGroup2, FolderGroup17"...

I have a gathering of items selected in a multi-select Listbox saved to a table as a comma seperated string. Can I use that string to re-select the listbox items, let's say, if the end user was re-opening to modify previous selections? I have code to parse and read from comma to comma - what...

:d you rock bob!

BOB - If there was a DUH emicon I would use it here - it was in the parsing on the code where Active Dir reads it! I have that fixed! I am so sorry I wasted your time - I just needed your Osmosis Jones!

Oh - I understand - It's getting thrown into a a sql statement and emailed. Added to table here: Sub AddEmpInfo() Dim mySql As String mySql = "INSERT INTO NewStaffRequests(RequestType, SubmittedBy, DateReq, StaffID, NewStaff_F_Name, NewStaff_L_Name, DepartmentName, DeptRU, Location...

If I can get this finished, I am posting as a how to - it's turned out to be a heck of a program. I am polishing off the code/commenting and trying to break it - because my boss promised me a trip to show it off...

NOPE - That is what that string builds and shoots as an email. I was just showing you the stoppage at 75 char

Hi Bob - you are quick today! Correct - looping through the value of the list box. Here's one list boxes code: '-------------SET DB Permissions---------------------------- If flag = 1 And Me.lbDatabase.ItemsSelected.Count > 0 Then 'Use global EmailGroups Dim var2...

I have a group of list boxes where the items selected are strung together to form a comma seperated list. This is getting truncated at 75. I changed the table design from a Memo field to a textbox 255 and it still truncates at 75. I read a post that it could look like this: strFolders =...

I HAVE IT WORKING and wanted to share the code! This has been a real pain in the butt endeavor but.... persistance overcomes. Couple things you should know - where ever you choose to run this code, you must install CDOEXM library/.dll files for use of that library with Access - whether...