lushh
Last Activity: Nov 6 '06, 01:45 AM
Joined: Jul 27 '06
Location:
-
thanks for the reply...the query did not work... it still returned zero results... -
thanks a lot for the reply.. it did work for my first query, but for my second query it didn't.. here's what i did with my second query:
...Code:SELECT tblEmployee.EmployeeNo AS [Employee Number], tblEmployee.LastName AS [Last Name], tblEmployee.FirstName AS [First Name], tblEmployee.MiddleName AS [Middle Name], tblCompany.CompanyName AS Company, tblDealer.DealerName AS Dealer, tblOutlet.OutletName AS Outlet, tblPosition.PositionName
Leave a comment:
-
Help with wildcards
hi guys.. i want to include a search form in my database.. here is my current SQL statement:
but...Code:SELECT tblCompany.CompanyIDPK, tblCompany.CompanyName, tblCompany.CompanyAddress, tblCompany.ContactPerson, tblCompany.ContactPosition, tblCompany.OfficeNo, tblCompany.MobileNo, tblCompany.FaxNo, tblCompany.EmailAdd FROM tblCompany WHERE (((tblCompany.CompanyName)=[Forms]![frmSearchClient]![txtSearchFor]));
-
Help with search function
hi.. i am currently creating an employee database.. and there is a form on
the database that needs to search on records.. i am planning to create a form
with a single textbox (for the keyword entry) and a search command button
that when clicked, the search results will be shown in a seaparate continuous
form.
now here is my query:
...Code:SELECT tblEmployee.EmployeeIDPK, tblEmployee.LastName, tblEmployee.FirstName,
-
Help with tracking of contracts
hi guys. i am just a newbie here. i am currently working on an employee
database using MS access 2003. i wanted to track all the contract dates of a
certain employee. is that possible?
whenever the user would enter a new contract date for a certain employee, it
will not overwrite the previous contract dates, hence it would add up to the
list of the contract dates for that certain employee...
... -
hi, thanks for the reply. yup, but will that option be available when i make an MDE file of that database? and as much as possible, i want to make the database formal and user-friendly since i won't be the end-user of this database.and i think it would be better to create buttons for report generations... =)Leave a comment:
-
Help with formatting an excel spreadsheet
hi guys. i am currently using ms access 2003. i want to export my reports to an excel file so i did a code like this:
Private Sub cmdActiveListBy EmployeeID_Clic k()
On Error GoTo Err_cmdActiveLi stByEmployeeID_ Click
DoCmd.OutputTo acOutputReport, "AlphaListi ng", acFormatXLS, , True
Exit_cmdActiveL istByEmployeeID _Click:
Exit Sub
Err_cmdActiveLi stByEmployeeID_ Click:... -
ok.. thanks so much.. yup it did help.. thanks guys... :)Leave a comment:
-
got it.. thanks... but there is an error message saying that "You cannot create a Human Resources Information System ADE or MDE file from a database saved in Human Resources Information System 2000 format. Convert the database to the current version of Human Resources Information System. Then create the ADE or MDE file." what does this mean?Leave a comment:
-
oh i see.. how can i create one? sorry i am just a newbie...Leave a comment:
-
sorry for the double post.. i just wanna clarify, what should i do if i don't want the users of my database to access the design view, database window and modify the database?Leave a comment:
-
thanks.. that worked... have a great day!!!Leave a comment:
-
How to access the startup options
hi guys.. i have already accessed the start up options on my database. i have unchecked the allow full menus, allow default shortcut menus, allow built-in toolbars, allow toolbar/menu changes and use access special keys options. the problem is that when i want to incorporate some modifications in my database, i can no longer access the toolbars. all i can see in my screen when i access the database is this:
... -
thanks for the reply guys! it really did help! good day!Leave a comment:
-
search form
hi guys. i need help on doing a search on a database. i am using ms access 2003 and the form looks like this:
http://i114.photobucke t.com/albums/n258/lushh_16/searchbyclientf orm.jpg
when the user will type in for example "EOT Corp." in the "Search for" field and will choose "Company Name" in the "Search by" combo box, the database will look for all the "EOT Corp." entries...
No activity results to display
Leave a comment: