Could someone please give me a link or place to find a descreption of all the "More Tools" that you can use when building a form. If I had a list I could pick what is best for my database and explain things better to management...thanks.
View RepliesI wanted a Switchboard page in Access to open automatically when the database was opened. I've done that but, as I did it, while in the Tools/Startup to set Display Form Page (in this case a switchboard page but it's not opening full screen and I ow have no way of editing anything), I stupidly de-selected the options there...
Display database window, Display status bar, Allow built in tool bars allow toolbar/menu changes.
Now I have lost the tools Menu, the View Menu and others (where one sees, File, View etc at the top of the window) and I can't work out how to get them out. I can no longer view my Access pages in Design View so I can't amend the any pages.
Can anyone tell me how to get my View and Tools menus back on my Access app window?? It's a bit of an emergency... been up all night and have to hand this in as coursework at uni in about 3 hours and I've screwed up right at the end and can't do the last couple of things before putting it on a CD for my tutor to mark.
Help!
I'd also like to know how to get it to open the first form at full screen.
Thanks.
Ceri
I've been trying to figure this out, but it looks like a no go.
I wanted to give my users the ability to create/modify queries, but NOT create/modify tables.
Does anyone know if this is possible in Access 2002?
Thanks,
Earl
I am new to Access but I worked with data and database before (but not with Access...). I am currenty trying to set up a database where multiple users will have to enter the data.
What I am struggling with is how to customize the form. I would like to make the form as easy as possible so that other users can easily enter the data. For example, how can I add the Description of the field in the form? Suppose the FieldName is Country, the Data Type numeric and the description is "List countries the study was conducted in" how can I make sure this appears in the form?I have used textbox under Form>Format but it does not seem to work: the textbox remains empty!
I'm trying to extract information from Err.Description within a form's Error event. Alas, Err.Description does not seem to be available from there.I have a form that normally displays in DataSheet view. If a trigger on the Oracle back-end raises an error, I want my Access app to be able to parse out Err.Description and deliver a more user-friendly message than ODBC's message. I want to get the info about the message from the error coming back from Oracle, not by matching up error codes.
If I change the form to Single-Form view and put a Save button on it, I can capture Err.Description in the command button's Clicked() event, and then parse out what I need.So if I must display this form in Datasheet view, where can I trap the ODBC error and display my user-friendly message?
I am very new at all of this. I am trying to build a filter form to just pick out one item. I am trying to filter out Box Numbers that have been entered into the database to run reports on them. I think that I am missing the correct code to do this. I have tried to create a form off the query by just using the box number and then creating a command button to apply the filter. But this doesn't work. I'm sure that I'm missing a step along the way. Help!
View 2 Replies View RelatedI have a split form on my database where I have my combo boxes bound to a primary key but they display the description field so it's much easier to understand. Is there a way to do this with option groups? In other words, I would like the datasheet part to display the option group labels rather than the values so it is easier to understand.
View 1 Replies View RelatedI was just editing my Access database (stored on the intranet) when a message popped up saying "Disk or network error".
I clicked the only option ("ok") and closed the DB. When I reopened it, it said someone else was viewing it and I only had read permissions. I close it again, and see that in the directory where my .mdb file is stored I have the .ldb file remaining even though it isn't open.
I restart my machine, and try and open it again. I have to compact and repair the DB at Access' suggestion, yet now I only seem to have limited functionality....??
I.e. there is no Tools menu, I can't right click on forms or tables to choose Design View (although if I highlight them in the database pane and click the BUTTON for Design View I am able to proceed)....
What's going on?!!
I've tried going to File > Open and in the little arrow on the Open button choosing "Open Exclusive", but it opens and does the same thing as above...!!
I've checked a different database in Access, and I don't seem to have gone potty, in every other one I'm able to see the Tools menu, etc...?
Anyone got any clues as to how I can get my lovely database back on its feet and functioning properly? :confused: :eek: :rolleyes: :mad:
hi there...
where can i find free access developer tools? please help..
thanks
Hello All,
I have made a critical error with my system, in tools on startup i unticked all the boxes, and now when it loads it brings up the system only and not the design view tables etc,
Is there anyway that this can be undone??????
*Can anyone tell me if or how to reffer to the options from Tools-->Startup in VBA code? I`m asking that because i want to open a database in different ways
taking in account the logged user.
*And another question: in access 2000 is possible to make .mde files? Because the option is dissabled in tools--> database utilities menu.
Many thanks,
bogdan
Hello,
I created a database, and was trying to get the welcome form, to load full screen. So I unchecked all Menu bar and Shortcut bar (allow)
So I now have locked my self out.
Any ideas, I once remember something like ctrl while opening the database, but that does not fix it.
Thanks,
Ranger
Although I have been using access for a year or two (self taught) I have only recently noticed that the form toolbox (the one with combo boxes and buttons etc on it) appears to have a library of procedure calls for calendars and all sorts of things sitting there waiting to be used. Is there a list somewhere of what all this lot does? I have been playing with a couple of date pickers but I don't particularly want to go through all of the rest to see what they do or if they would be useful.
Thanks
Hi Guys & Gals,
I have a report that runs a number of queries via a macro in the on open property. These queries populate a table used in the report. The on close property runs a query to clear the table contents.
When a user ran this, he had a flurry of warning notices which I tracked down to the Confirm settings in the tools/options/edit find tab.
Is is possible to set these using vba?
I guess that this could be achieved using send keys, but this would probably be a bit clumsy - to say the least.
Can it be done so that the settings are changed only for the current session so that users have the original settings?
Any thoughts welcome.
Regards,
Keith.
Hello,
I've read most of the General category on Toolbars and Startup Menus, but still can't figure this out. I have no VIEW or TOOLS on my toolbar, so I can't get to the startup menu, toolbars, or anything else. When I go to Customize, one option is Built-in Menus. When I try to drag the VIEW or the TOOLS to the menu bar, it won't happen. I have tried the Shift trick, but it did not work either. Can someone help me?
I am building a tool rental data base.I have places a delete button on my Transfer form so the operator can erase any mistake that he/she just made on a Transfer ticket.When I push the button I get an error message saying that I can't delete the record because it is associated with 2 tables. I have one table the tracks the transfer and another that tracks the tools associated with the transfer.How can I delete the transfer and the associated tools records?
View 2 Replies View RelatedI want to hide external data and databasetools tabs only from my access program. How i do it ?
View 3 Replies View RelatedDear All,
I want to make a multiple criteria query from active form,
but i stuck in SQL ,Please help to solve my syntac. I am very fool in Sql Syntac. the code like bellow:
Option Compare Database
Private Sub cmdSearch_Click()
On Error GoTo cmdSearch_Click_Err
Dim blnQueryExists As Boolean
Dim cat As New ADOX.Catalog
Dim cmd As New ADODB.Command
Dim qry As ADOX.View
Dim varItem As Variant
Dim strUmur As String
Dim strJnsKelamin As String
Dim strPendidikan As String
Dim strPosisi As String
Dim strJnsKelaminCondition As String
Dim strPendidikanCondition As String
Dim strPosisiCondition As String
Dim strSQL As String
'************************************************
' Check for the existence of the stored query
blnQueryExists = False
Set cat.ActiveConnection = CurrentProject.Connection
For Each qry In cat.Views
If qry.Name = "PelamarTemp_Qry" Then
blnQueryExists = True
Exit For
End If
Next qry
' Create the query if it does not already exist
If blnQueryExists = False Then
cmd.CommandText = "SELECT * FROM Pelamar"
cat.Views.Append "PelamarTemp_Qry", cmd
End If
Application.RefreshDatabaseWindow
' Turn off screen updating
DoCmd.Echo False
' Close the query if it is already open
If SysCmd(acSysCmdGetObjectState, acQuery, "PelamarTemp_Qry") = acObjStateOpen Then
DoCmd.Close acQuery, "PelamarTemp_Qry"
End If
'************************************************* *
'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^
' Build criteria string for Umur
strUmur = Me.Umur.Value
Debug.Print strUmur
'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^
' Build criteria string for JnsKelamin
strJnsKelamin = Me.Jns_kelamin.Value
If Len(strJnsKelamin) = 0 Then
strJnsKelamin = "Like '*'"
Else
strJnsKelamin = "IN(" & strJnsKelamin & ")"
End If
Debug.Print strJnsKelamin
'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^
' Build criteria string for Pendidikan
strPendidikan = Me.Pendidikan.Value
If Len(strPendidikan) = 0 Then
strPendidikan = "Like '*'"
Else
strPendidikan = "IN(" & strPendidikan & ")"
End If
Debug.Print strPendidikan
'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^
' Build criteria string for Posisi
strPosisi = Me.Posisi.Value
If Len(strPosisi) = 0 Then
strPosisi = "Like '*'"
Else
strPosisi = "IN(" & strPosisi & ")"
End If
Debug.Print strPosisi
'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^
' Get JenisKelaminCondition
If Me.optAndJnsKelamin.Value = True Then
strJnsKelaminCondition = " AND "
Else
strJnsKelaminCondition = " OR "
End If
Debug.Print strJnsKelaminCondition
'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^
' Get PendidikanCondition
If Me.optAndPendidikan.Value = True Then
strPendidikanCondition = " AND "
Else
strPendidikanCondition = " OR "
End If
Debug.Print strPendidikanCondition
'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^
' Get PosisiCondition
If Me.optAndPosisi.Value = True Then
strPosisiCondition = " AND "
Else
strPosisiCondition = " OR "
End If
Debug.Print strPosisiCondition
'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^
'************************************************* *
' Build SQL statement
'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^
'SQL Statement from Query builder
'SELECT Pelamar.No_pelamar, Pelamar.Tgl_lamaran, Pelamar.Nama, Year(Now())-Year([Tgl_lahir]) AS Umur, Pelamar.Jns_kelamin, Pendidikan.Ijazah, Posisi.Posisi
'FROM ((Pelamar INNER JOIN Pekerjaan ON Pelamar.No_pelamar = Pekerjaan.No_pelamar) INNER JOIN Pendidikan ON Pelamar.No_pelamar = Pendidikan.No_Pelamar) INNER JOIN Posisi ON Pelamar.No_pelamar = Posisi.No_pelamar
'WHERE (((Pelamar.Jns_kelamin)=[Forms]![SearchByKriteria_frm]![Jns_kelamin])) OR (((Pendidikan.Ijazah)=[Forms]![SearchByKriteria_frm]![Pendidikan])) OR (((Posisi.Posisi)=[Forms]![SearchByKriteria_frm]![Pendidikan])) OR (((Year(Now())-Year([Tgl_lahir]))<=[Forms]![SearchByKriteria_frm]![Umur]));
'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^
'Please I am very stupid in sql,how to apply all variabel that i had create and insert in the sql in vba?
'i had try write as bellow but the result is error number 2465 with error description "Microsot Access can't find the field"I" reffered in your expression"
'All i need is how to write SQL in vba like the sql statement in query builder for make a query on form.
' note: all variabel string is all from the form
'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^6
strSQL = "SELECT Pelamar.* FROM ((Pelamar INNER JOIN Pekerjaan ON Pelamar.No_pelamar = Pekerjaan.No_pelamar) INNER JOIN Pendidikan ON Pelamar.No_pelamar = Pendidikan.No_Pelamar) INNER JOIN Posisi ON Pelamar.No_pelamar = Posisi.No_pelamar" & _
"WHERE Pelamar.[Jns_kelamin] " & strJnsKelamin & _
strPendidikanCondition & "Pendidikan.[Ijazah] " & strPosisiCondition & _
"Posisi.[Posisi] " & strJnsKelaminCondition & (Year(Now()) - Year([Tgl_lahir])) = " strUmur "";"
Debug.Print strSQL
'************************************************* *
' Apply the SQL statement to the stored query
cat.ActiveConnection = CurrentProject.Connection
Set cmd = cat.Views("PelamarTemp_Qry").Command
cmd.CommandText = strSQL
Set cat.Views("PelamarTemp_Qry").Command = cmd
Set cat = Nothing
' Open the Query
DoCmd.OpenQuery "PelamarTemp_Qry"
' If required the dialog can be closed at this point
' DoCmd.Close acForm, Me.Name
' Restore screen updating
cmdSearch_Click_Exit:
DoCmd.Echo True
Exit Sub
cmdSearch_Click_Err:
MsgBox "An unexpected error hass occurred." _
& vbCrLf & "Procedure: cmdSearch_Click" _
& vbCrLf & "Error Number: " & Err.Number _
& vbCrLf & "Error Description:" & Err.Description _
, vbCritical, "Error"
Resume cmdSearch_Click_Exit
End Sub
Private Sub optAndJnsKelamin_Click()
If Me.optAndJnsKelamin.Value = True Then
Me.optOrJnsKelamin.Value = False
Else
Me.optOrJnsKelamin.Value = True
End If
End Sub
Private Sub optAndPendidikan_Click()
If Me.optAndPendidikan.Value = True Then
Me.optOrPendidikan.Value = False
Else
Me.optOrPendidikan.Value = True
End If
End Sub
Private Sub optAndPosisi_Click()
If Me.optAndPosisi.Value = True Then
Me.optOrPosisi.Value = False
Else
Me.optOrPosisi.Value = True
End If
End Sub
Private Sub optOrJnsKelamin_Click()
If Me.optOrJnsKelamin.Value = True Then
Me.optAndJnsKelamin.Value = False
Else
Me.optAndJnsKelamin.Value = True
End If
End Sub
Private Sub optOrPendidikan_Click()
If Me.optOrPendidikan.Value = True Then
Me.optAndPendidikan.Value = False
Else
Me.optAndPendidikan.Value = True
End If
End Sub
Private Sub optOrPosisi_Click()
If Me.optOrPosisi.Value = True Then
Me.optAndPosisi.Value = False
Else
Me.optAndPosisi.Value = True
End If
End Sub
'^^^^^^^^^^^^^^^^^^^^^^^^^^^^^66
Is there any one can correct my syntac?
i want to hide external data and databasetools tabs from my access program.
how i do it ?
I have created a simple login form that is based on User Name and Password.the table contains UserName, First Name, Last Name, Password and User Role(dev, admin...ect.)How can I change who can access different parts of the database?I want all the Development tools only accessable to People who have "dev" as a "User Role".Admin can only access the forms related to data entry and managers can view all forms but not the tables, querie and tools...ect.
View 3 Replies View RelatedI was contacted today by a staffing agency and was told that I looked like a good fit for a Data Analyst position. The agency and wanted some more information about my resume and wanted me to email them my references. Next step I would assume would be an interview.
I did want to post the responsibilities of the job and see if other DBAs thought it looked like entry level work. The only thing I know about the company is that they are automotive and pay is under 40K. I have been trying to break into IT for the past few months and this looks like a great opportunity. :) I appreciate your comments.
-Jon
Scope of Work:
Provide analysis support for the following: reduction of engine warranty costs, improvement of field reliability, identification of root causes, and development of new data systems. Position also monitors and reports effectiveness of actions taken.
Perform data analyses in support of problem-solving teams and management decisions, to include identification of root causes, determination of population(s) affected, failure rate estimates and projections, and estimated warranty impact.
Play a supporting role in the development of new custom-built data systems aimed at informational support of warranty analysis and reducing the time and cost of doing business.
Maintain SQL Server and Access databases of supporting information for reliability analysis to include: warranty claim information, failure modes, product improvements.
Support maintenance of custom warranty analysis software (RAS); includes troubleshooting data issues, updating information tables, and checking validity of system data.
Other Projects as assigned.
I have a scheduling unit that associates a number to a particular name.
In this example Break=66 and Lunch=76.
What I would like to do is setup something that will tell me "which break". Like "Break 1" and "Break 2"
Here is what I have to work with:
Emp# ID# Code StartMin Desc
6666 5555 66 870 Break
6666 5555 76 1005 Lunch
6666 5555 66 1150 Break
I tried this thinking it might designate it based on the StartMin:
Desc: IIf([Code]=66 And First([StMin]),"Break 1",IIf([Code]=66 And Last([StMin]),"Break 2","Lunch"))
However this still just shows each as "Break 1". Any ideas would be great. Thanks.
I am wondering if it is possible to use a wildcard in an update query. I would like to add text (the same word) to the end of the line item description where the starting text values are different.
example:
want to add Quantum
beginning value is:Trendsetter II -> new output value would be "Trendsetter II Quantum"
Lotem 800 -> Lotem 800 Quantum
8up -> 8up Quantum
I was wondering if it would be possible to type in a description eg.(Days, nights, O.T.,ect.) and have excell automatically insert the rate I specify into another cell.
View 1 Replies View RelatedI am new to access and I am trying to build an inventory management in access.
I have a table with all the inventory and has the following form:
Item ID - Description - Quantity
Item Id is used and in other tables (which are linked to basic inventory table), and I want to add and the column "description".
But I would like when I am typing item Id to autoshow the description. Is it possible?
Option Button Description table
I would like to create a table containing description value of my option button group.
This is my description table:
tblLenkeDESC
IDLenkeDescLenkeDESC
1Lenke 1
2Lenke 2
3Lenke 3
4Lenke 4
5Lenke 5
6Lenke 6
And this is my table containing selected option from the form:
tblLenke
IDIDNameLenke
114
225
336
441
552
How can I associate description with the selected options?
Many thanks,
Debbie