birchw
Last Activity: Jan 24 '08, 01:44 PM
Joined: Oct 19 '06
Location:
-
Thanks guys for the advice. I think this is going to be more time and effort than it's really worth :-) -
Give users the ability to query a database using SQL
Hi
I have a database in Access 2000, for which I would like to give users with a certain amount of SQL knowledge the ability to query it themselves. This would save me a great deal of time and effort! The way I would like to do this is to have a form with two windows - the top window being where the SQL is written and the bottom window being the output, perhaps in a datasheet format. The permissions will need to be limited, i.e.... -
Thanks guys.Leave a comment:
-
Problem solved. It was indeed pointing to the secured.mdw file on the network drive.
Thanks once again for your patience and support.Leave a comment:
-
I don't seem to have Workgroup Administrator (or at least it's not under Tools, Security) - is there any other way I can access this?Leave a comment:
-
Securing a Wireless Network
Hi, I was wondering what the best way is to secure a wireless network - on my network I have employed mac address filtering and 128 bit WEP encryption... but I've heard a lot of stories that WEP is quite easy to hack, and WPA is better?
I look forward to a reply.
Thanks. -
Thanks MissingLinq, that resolved that issue. I have two versions - one in C:\windows\syst em32 and another in c:\program files\common files\system. I replaced them both with a copy from someone else's machine, but the original issue is still occuring. If I delete the secured.mdw file from the network drive where my database is, I then get an error stating 'Microsoft Access could not find file system.mdw. This file is required for startup'. I.m...Leave a comment:
-
No problem, thanks for trying. I'll see if I can copy one from someone else's machine.Leave a comment:
-
Thanks. Just one problem though... I've run a search and there are no *.mdw files at all on my C: drive - there is however an mdw file in the same folder as my database, called Secured.mdw, which is located on a network drive.Leave a comment:
-
Thanks NeoPa. Looks like I'm going have to reinstall. Thanks for your help.Leave a comment:
-
birchw started a topic Problems with Security - Group Accounts, Group Permissions and Security Wizardin AccessProblems with Security - Group Accounts, Group Permissions and Security Wizard
Hi, having never used the security features under the tools menu in Access 2000, I thought I'd experiment with them on a copy of my database. Or so I thought! Everything was going well - I successfully set up a new workgroup file, defined a new group, set permissions, user names, passwords, etc until I realised that whatever it is that I've done, every database I go into (including the master!), regardless of whether it was created by me or not,... -
Thanks guys for your prompt responses. I've incorporated the function into my database, rather than testing it in the immediate window and the results are OK. You learn something new every day...Leave a comment:
-
Function issue to calculate age from birthday
Hi,
I downloaded a function from the Microsoft Knowledge base to calculate a persons age as at the current date based on DOB. The function is as follows:
Function Age(varBirthDat e As Variant) As Integer
Dim varAge As Variant
If IsNull(varBirth Date) Then Age = 0: Exit Function
varAge = DateDiff("yyyy" , varBirthDate, Now)
If Date < DateSerial(Year (Now),... -
Try this...
MonthsAgo: IIf(DatePart("m ",[EFFDT])=DatePart("m", (DateAdd("m",-1,Now())),"-1"),
IIf(DatePart("m ",[EFFDT])=DatePart("m", (DateAdd("m",-2,Now())),"-2"),
IIf(DatePart("m ",[EFFDT])=DatePart("m", (DateAdd("m",-3,Now())),"-3"),
IIf(DatePart("m ",[EFFDT])=DatePart("m", (DateAdd("m",-4,Now())),"-4"),...Leave a comment:
-
To change the name of the combo box, just change the Name property of the combo box to EnterCourseNumb er (try not to use spaces for field names).
If you want Enter Course Number to appear on the form, just edit the label and change the Caption property.Leave a comment:
-
Rather than have the parameter in the query, create an unbound form and add a combo box control to the form. In the rowsource property of the combo box, make this the table that you are getting the data from (whatever table your query is looking at). If you now open the form, the combo box will contain the data on the table. You can use this combo box to select data from the query, by replacing your parameter in the query with the name of the combo...Leave a comment:
-
Thanks. That worked. I didn't realise there was a Round function as it wasn't listed in the functions list within the Expression Builder.Leave a comment:
-
Sorry, I forgot to mention that this is Access 2000, and there is no round function. All I need to do is remove the fractional part, but not round it. Thanks.Leave a comment:
-
Query - incorrect output when usingthe INT function
Hi, I have a field in a query, as follows -
SharesToPurchas e: [TotalCash] / [Forms]![frm_EnterPurcha seDetails]![txtEnterPurchas ePrice]
where [TotalCash = 272.58, and [txtEnterPurchas ePrice] = 6.49. Dividing [TotalCash] by [txtEnterPurchas ePrice] should come to exactly 42.
This is the only case in my data set where the result works out to a whole number - the rest have fractions. They should all be whole numbers....
No activity results to display
Leave a comment: