Search results

It breaks on the following line: myUser.Groups.Delete curGrpName

I'm trying to delete or remove a group membership for a user. I get the following error when I execute my code. "Item not found in this collection." What am I doing wrong. Here's my code: Dim dbs As Database Dim frm As Form Dim uName, upid As String Dim ws As Workspace Dim myUser As User...

thanks for your help. I figured it out. The stupid database that I was trying to import from was in a read-only state. I found that I when I ran a compact/repair. It compacted it and saved it as db1.mdb then I was able to export the data.... WOW .. Access can be crazy at times. thanks again

I'm trying to simply import a table from 1 database to another. Both databases reside on my computer's local hard drive. There is no security workgroups attached to either database. The table that I'm trying to import has 80,000 lines (records). My problem is that the import times out and...

Is there a way to add an already existing database to a workgroup? I have two databases that are linked togeter that I need to setup security for both. They should use the same workgroup file. The only way I know how to do it is to create the workgroup file, then create a blank database under...

I simply want to reverse the stacks in my bar chart. My chart shows total ERTs and total NON ERTs. Total ERTs is green and Non ERTs is blue. The blue bar is on top of the green bar. I want it to be in reverse (green bar on top of the blue bar.) See attached graph. It seems so simple but I...

Hi Doc_Man, I'm joining this thread a little late I hope you will be able to help me. I am pretty proficient with VBA and I know exactly what you're talking about when you say add the reference. I am trying to do exactly what you all were discussing which is control my graph through code. I...

I have a pie chart with 5 categories. The legend is color coded. But if one of the categories is 0 then the corresponding color for that category is moved to the next category. For example. 1 = green 2 = blue 3 = yellow 4 = orange 5 = red If category 1 has a total of 0 then the legend colors...

OK .. forget my last question. I figured out how to populate my listbox. But now my problem is : I have a for next loop and within that loop I show the userform with the listbox. After the user completes an action on that userform I need to go back to continue with the "next" row in my for...

I am trying to set the value of a text control when I show my userform. The value that I'm trying to set the control to comes from a variable that's on another user form. So for instance: I have two UserForms ... (UserForm_1) and (UserForm_2) on UserForm_1, I cycle thru the rows and capture...

Yes. This helps a little. But will I need to use the MS Access pages? I do know .net and some ASP. How do I use the MS Access pages objects with these languages. I guess I need to know what my first step should be.

I need to turn my access database into a web-based application. Can anyone point me in the right direction with that. What software would I need? What type of server? And how to publish it to the internet. I know this may not be where I can get help on actually setting it up, I just need to...

Yes, I tried that too. I don't know what is wrong.

I have the following value in 1 field: Latoria V This value clearly has a space. When I use the Instr function to return the position of the space, it returns 0 and it returns 0 for all of the records. The field has a first name, space, then middle initial. Why is this? This is th function...

thank you buddy! that worked.

I'm trying to simply pass a variable to my report. I have a report named "rptMonthlyStatistics". And a unbound control named "totCompleted". On Open event of the report I am calling a function named "getMonthlyStats". The code for that funtion is here: Dim dbs As Database Dim myqry As...

Wow thanks!!!! is that vb or dos language you're using? How do I check to see if the file exits? Like in my vba code I use the If fs.FileExists

thanks but that's my problem. I have no idea how to write the batch file, what to save it as, and how to run it and where to run it from. Do I save the text file with an extension of .bat? Then just click on the .bat file?

I'm having a problem executing this script. I put the following code in a notepad file and saved the file as "hosts.vb". I clicked on the file and it didn't do anything. How do I execute that code. from my file? Dim OldName As String, NewName As String Dim fs As Object Dim SourceFile...

thanks maxmangion. but I meant to ask if you can create VBA script using notepad and execute that? I'm sorry.