Search results

No need to reply, i found it.

im creating a form in design view but the icon to show the fields from the table that i want the fields to come from isnt being displayed; how do i get it to show?

Any Ideas? Im still no closer to getting around this problem, the thing is though ive done some reading and based on the error message and the line of code that was highlighted i realise that its something to do with the DAO. My question though is how do i get this to not only work when i feed...

Okay it turns out that someone is doing a printer inventory that they want me to add to this database. Im going to attach a copy of the Relationships and the tables that i have so far. By the way i cant over-emphasize the magnitude of the gratitude that im feeling.

Im gona give this a litle break but you guys have been rather helpful .. Thanks. Its encouraging to know that i can undertake any task and if i rrun into probs i can link some one. I'll be sure to add some more questions as they arise.

Ok so here is what ive done so far 1. Created a table called components with just component ID and The Component Description field 2. Created a Machine Specs table with Service TAg # for the machine as primary key, Component ID, Specification e..g DVD+R or 10GB e.t.c. anda Date Installed...

Ok I understand what you're saying about the normalization thing just now. The thing is i wana get as best a setup for this thing. By the way there are some guys here that dont think access is worth anything which is why i really wana do a good job at the structural level of this assignment.

Thanx for the reply, could you just be a little more specific about the components table and the relations table. theat kinda hazy in my mind

Im creating a db to keep records of computers that have been assigned to persons in their various departments and also unassigned computers and spare parts. problem: For the machine specifications table should i put in the following fields as columns Hard Drive 1 Hard Drive 2 Hard Drive 3...

Thanx bt this doesnt really help becuase i want it to do the following 1. My listbox displays all of the records in the table 2. when i type in my information in my search text box then it narrows the data in the list box 3. When i click the record in the listbox then it should display the...

I want to put a search form (text box and listbox) on a form that has the records displayed.Can i please get some help with codes. Ive been searching your forums but the problem is that most of the search forms are linked to pop-ups. Can someone PLEASE help me.

So are you saying that i should create a button. Im not good at this. I just search the forums and copy codes from the attachments and they always seem to work. Yes the listbox is connected to my table that is where it takes the data from and displays it. The thing is that it does work when i...

Private Sub quicksearch_AfterUpdate() Dim db As DAO.Database Dim rs As DAO.Recordset Set rs = Me.Recordset.Clone rs.FindFirst "[ID number] = " & Str(Me![quicksearch]) Me.Bookmark = rs.Bookmark End Sub this is the code that im using to help me with a...

I have a field called "Bad Pc Part" which is a listbox. THe problem is I want it to display the contents of 3 other fields from another table. I created a query for the Bad Pc Part field but the problem is it only displays the information in the first field of the table. It doesnt show the...

Thanks Hey thanks for the code ghudson. Really appreciate the help.

Listbox My main form that displays the records also has on it a listbox for easier navigation to records. What i would like is when i delete the records, they automatically become removed from the listbox. Currently what happens is that i have to close the form and reopen it in order for the...

My subform when i click the New record button on the subform i want it to disable a text box that is on the main form. Me.Pensioners.Form!quicksearch.Enabled = False where Pensioners is the name of the Parent Form. Thhis isnt working for one reason or another. Please advise.

i have a form porblem. I have a search form embedded onto my main form its really a listbox that when i click the records in it they display the record. prob;em is that when i delete the record it still shows in the listbox

I have a main form and a sub form. Tbhidden and tbpropersave are the text boxes that govern the update procedure. The main form has two text box that i use to prevent the user from modifying the information on the main form without clicking my custom save button. the problem is that the subform...

hey im a newbie to access. I was wondering how to create a button that allows me to enable fields which by default are set to disabled. I read some thread and got that part to work using the me.subforname.controlname.enabled = true. How do i creat a button to do the opposite, to disable the fields.