Recent content by GumbyD

I would like to copy an existing security group into a new security group and then make some minor changes to the security on some of the objects for the new security group. Does anyone know of a way to do this? Thanks!

Is there another table called Bookings or something? How are these tables related - is it through a third table? If you post the database I will try to create an SQL statement you can just copy.

Is there another table called Bookings or something? How are these tables related - is it through a third table? If you post the database I will try to create an SQL statement you can just copy.

You should be able to create queries to get the information you want if your database is built correctly. You may want to post your database so people can look at and give you suggestions about how to accomplish what you need. No one will be able to help you without know the table structure...

One thing to check - if you imported the database into your computer and you are using Windows XP - check the properties of the file. You may see a area on the properties window that says the file is locked or something like that. I have seen it before - I don't think I have the nomenclature...

I took a look at your database. If you add this function to a new module and then run use the query below I think it will give you what you want. code for new module Option Compare Database Option Explicit Public Function CalcBal(AcctNum As Long, LDate As Date) As Currency Dim sql As String...

what if you did something like this: txt_UserName = UCase(txt_UserName) Select * from Qry_Filter where "UCase([USERNAME]) LIKE """ & txt_UserName & "*""" It is odd because I have not seen case cause criteria to not work before, but if it try the above.

I think you will need a bit of code. I tried to replicate a bit of your database and create the query and code you will need. Take a look at the attached database and see if that can get you where you need to go.

What datatypes are the two fields you are multipling? If either of them is non-numeric, you will either need to change the datatype or use a conversion function to convert the data to a numeric datatype (cint converts to an integer, cdbl converts to a double). You could try this expression...

Try this SQL - you will need to replace all references of Rec_Table with your table/query name. You can paste this in the SQL view of a query. PARAMETERS [Enter Date] DateTime; SELECT Rec_Table.rec_Date, Rec_Table.rel_Date, Rec_Table.weight, Rec_Table.[PO#] FROM Rec_Table WHERE...

I see what you are trying to do, but I would recommend a different approach. I am hoping that your report runs off of a query and not a table - if not you will need to make a query with the table as your data source. Then on the form you are using, where you want to display the report from...

Check your export template to make sure the fields match with the table/query you are exporting. If the template does not match your fields then you get the highly mis-leading message. Good luck

For the first senario try: UPDATE Table SET Table.FICO = ([TU]+[EFX]+[XPN])/3; For the next senario try: UPDATE Table SET Table.FICO = IIf([TU]<[EFX],[TU],[EFX]); The last two are just variations on the second SQL

Rick - Can you post your database so I can see what you are looking at. If you are getting user information from the Access security area are the three divisions you are talking about Groups you have created (Support, Full, and Read Only) or is this a database that tracks a users access to...

OldsoftBoss - I like the addtion!