Search results

I am using code to list the groups a specific user belongs to with the following code: Set wrkDefault = DBEngine.Workspaces(0) usrNam = "tanya" Set usr = wrkDefault.Users(usrNam) For Each grp In usr.Groups Debug.Print grp.Name Next grp That code works fine the first time. But when I...

Thanks. I got the transfer database method to work.

Thanks Trevor , but the database is secured and I need to create the same database and associate with a different database workgroup.

I want to cycle thru each object (all tables,forms,queries,macros & modules) in my database and export it to another database keeping the same name for the object. I know how to export 1 object at a time but I can't figure out how to cycle thru the object collections. Does anyone know how I...

Its not working :( I have no idea what I'm doing wrong. when I set my variable to 1 value it works but if it has more than 1 value of criteria it displays nothing .. For example .. if i ask my query to return questions where question# = 1. Then that works fine .. but when the criteria is 1...

I have my public variable and functions set up the same way ... I can't figure out why mine isn't working.

I am having a very difficult time with such a simple task. I simply want to pass a public string variable that currently holds the value of "1 or 2" to my query as criteria for which questions to return. So here's what I have. Public wrongAnswerCriteria as string wrongAnswerCriteria is...

Ok. Thanks. I used the instr function but now my value displays a symbol instead of the actual line feed. How do I get my query to recognize the chr(10)? Here's what I have in my query: Left([Full Question],InStr(1,[Full Question]," ")) & Chr(10) & Trim(Mid([Full...

Is there a way to strip spaces that are in the middle of a string? I know the LTrim,RTrim & Trim functions for trailing, leading & both spaces but what about in the middle. For example: The sentence below was imported from a spreadsheet into one field and it treated the hard line feed as a...

OMG .. It works. I had the wrong date entered into the table. I'm sorry for that. Thanks again though.

Yes. curDate returns 07/02/2010 10:18 myStart returns 07/19/2010 17:00

I am trying to check if the current date is between 2 other dates and I can't figure out a way to write an expression. For example I want to know if today's date (7/20/2010) is in between 7/19/2010 and 7/26/2010 ... Here's what I have below: I have 4 variables and a sql statement that I...

I have 45 users that need to be removed from one group and added to another. I have a program that creates the users and appends them to a group. I loop through a table. I just need to know the proper syntax. I don't know why its giving me the error that the item isn't found in the collection.

I'm trying to remove users from a group. Can someone please tell me what I'm doing wrong here. I keep getting an error that the Item isn't in the collection. here's my code: Dim ws As Workspace Dim db As Database Dim rst As Recordset Dim NewUser As User Dim grp, grpUsers, grpAdmins As...

I am trying to figure out a way to change the filter settings for my report without having to close out the filter form or report. For example: I have a parameter form where you can select a name or leave it blank and you can select a date or leave it blank. Then I have a button that opens the...

Hi , I am trying to have criteria set in my query from a pop up form. My form has the following controls: [cboLocation], [startdate], [enddate] and [name]. Then I have a button that calls a report with [qrySource] as the source for the report. I need to set my query up to accept the values...

Thanks for the quick response. This is a group mailbox that I have access to. I can manually change the "From" to send from this group mailbox. I just figured I should be able to do it using VBA as well. How do you use the SendUsingAccount? is SendUsingAccount a method or property? I put...

I have some code that automatically sends a HTML formatted email from Access. What I would like to additionally accomplish is changing the "FROM" column programatically. The email should be coming from a group mailbox but whoever is clicking the button, will be captured as the sender. Is...

I have a weird issue. Here goes. [cboSearchby] .. displays "RequestorID" which is an integer and "RequestorName" which is text. [cboFind] displays the values based on what was selected in [cboSearchby]. So requestorID returns all numbers and requestorName returns all text. The problem is...

thanks guys.