Search results

On my login form, after the user enters the username and password he will have to go manually using the mouse to point at the Enter command button, is it possible to make in a way that after the user enters the password and hit enter proceeds as clicking on the enter command button

When I open my form the data are sorted through the ID, How can I change that to be sorted through the Year? On my form properties is that the Filter is responsible for sorting?

I have done the mistake of not keeping a backup, what I did is split my database file access and then created my mde file, I need to change some data on my tables, but I get the msg that I cant edit a linked table, is there a way that I could put things back the way it was, also this path that...

After creating my query based on some combo boxes [Forms]![DailyWorkReport]![commonth] which are located on my form I do have a command button that will open the results in a report, how can I show the results on the current form? I have added an image to make things easier

how can i show the name of the current month, using the default value, I use day(now()) and year(now()). I tried using month(now()) and monthname(now()) but they don’t seem to be working! any help? Thanks

I have table with filed with jobs that our IT’s have done for that day, the table is updated daily, based on my table I have created my query, I have set some criteria for some fields though, as follow: Month = [Forms]![DailyWorkForm]![commonth] Year = [Forms]![DailyWorkForm]![comyear] ITName =...

I have a form with four combo box that will search for a record, as follow: Field Name "Printer" , DataType "Text" Field Name Month" , DataType "Text" Field Name "Year" , DataType "Number" Field Name "Day" , DataType "Number" code for Find Record Button: If Not IsNull(ID) And Trim(ID) <>...

I have a month field on my table, I have tried to ass "Now()" on the Default Value, but its not seems to be working, what I want is when the form is opened the default value would be the current month. Thanks.

I need a button that will open a report based on the selection of my 2 combo boxes on my form: find = "select count(*) from Records where Month = '" & commonth & "'" & "and Year = '" & comyear & "'" How can I open my report based on this query. Thanks.

Deleting and adding from a table I have a form that has a list; the list is retrieving some names from a table. e.g Table name is “ITname” and I have a filed named “name” with the following: john, peter, mike, rock. On my form under my list I have a delete button, I want to the button to...

Still not sure how to do this, after I convert my database and create an mde file few changes might accrue in the future, I have tried to make some changes for testing purpose and then create a new mde file and saved it with replacing the older one but I had lost my new data which was entered in...

I use office 2003, first I had to convert my database, then I did the database splitting then, remove all menus from running at startup, I tried to create an mde file but it didn’t work. This is what I got: This error is usually associated with compiling a large database into an MDE file...

is it possible to open a current record in a report, what I mean is while the user is going over the records and lets say that he wanted to print the current record I need to open and print that record in a report so it would look more professional, how can I do that? Thanks.

I think I am missing sth here, after I set my new group then I create my new user, then what! How can I specify which user to login with? Will the user be promoted for a username and a password?

I am not sure but this how it should work in VB, I am trying to disable a button that exists on a different form: ACAudio!Command89.Enabled = False Where ACAudio is the name of the form and Command89 is the name of the button but I keep getting an error saying object required.

Enable/Disable table or form? After setting both accounts if user is accessing the database then I want to disable him from editing or adding a new record sth like this Form(name).enable = false and if the user is admin then he can edit and add records Form(name).enable = true, is that...

The strSql string should find the record that I have already saved in my admin table and then compare it with combusername, where is my mistake. Private Sub Command7_Click() 'Dim db As Database Dim strSql As String 'Set db = CurrentDb() strSql = "Select adminpass From admin" If...

Can anyone tell me whats wrong with this code, its not working for me!! If ((txtpassword = "") Or (combusername = "")) Then MsgBox "Please Enter A Valid Access", vbOKOnly, "Error" End If

I want to create and mde file in order for the users not to change any thing on my design, I will be uploading the file into my server and give them the path to access: 1. 3 people (max) will be accessing the database, is that a problem or not? 2. I cant create an mde file I have to convert my...

When the application starts up I need to control the user of the system, I will have to accounts which I will define one will act as an admin and the second will act as a user the differences is that the user acts is “read only” cannot add, delete and edit. I would appreciate your comments and...