Search results

Thanx I thank you for your suggestions and concerns

true enough I have thought of that and it is a very valid argument. What worries me is specific to the database i am creating. I have a table with columns describing functions on a device. I am worried that an empty field may cause the person who is entering the data to think that the record is...

I was wondering if there is a way to have a default value in a table field which is dependant on whether there was data enterd in said field or not. For example. I do not want any blank fields on my table instead I want "N/A" in the fields that were not used. I have tried setting the "default...

hmmmmmmm I'm not sure I understand. I couldn't find any threads on this problem. Any search tips??

I have a combo box(based on a table) on a form which autofills 12 textboxes. The problem is when i switch to the next record on the form the auto filled textboxes stay the same as the first record. when a new item is selected from the combo box all the records are changed once again. I dont know...

thanks your suggestion worked partially. the list box does update ...but only after another item is selected. is there any way to update the first time you click on the down arrow of the list box? Onclick doesnt seem to work

I have a form with a listbox in it. the list boxed is used to select an item to view in the sub form. All is well except when i try to add an item to the list box. I have set up a macro to enter new data in the list box by opening the table that supports it and entering the new data. what i need...

I'm a Singer/Songwriter. If anyone would like to hear some independent music take a listen...all but 2 of these songs(On Our Way, and When It Rains) were recorded in my living room. The 2 that werent are studio recordings. All of them are 100% mine :) I'd like to hear what You all think. So Take...

Now were talkin' Great, got it, and it works. Thank you very much. I apologize for making you repeat youself. There are a lot of posts to this effect I just couldnt get it up and running. I dont know what was going on, It maybe because i was trying to open the file from source instead of saving...

Maybe I misunderstood but I have seen numerous threads that imply otherwise, GHudson posted a sample I just couldnt open it.

I would like to change the color of the actual access database background. I've done my forum searching and found many many threads explaining how to do this but i cant open any of the sample DB's. Access says the file is readonly and you need to be able to edit upon the first opening or...

I have tried searching the forum to no avail, although I know it must be on here somewhere. I wanted to know if it was possible to have suggested text in a form field. If I type in "B" I would like previous entries begining with B to come up as suggestions for the complete word. Could some one...

boo :D boo....thanks for the reply

oh sorry for not being more specific...i mean the actual form window border...I'm starting to think the only way is the actual Windows XP settings, But here's hoping :)

Could someone tell me how to change the border colors on a form. There are lots of posts on changing txt border colors and such but i want to change the form border its self.

The Audit Trail function (GHudson) on my form is still working wonderfully. But I was wondering, will it add alot to the overall size of the DB? It seems to record a lot of information (which is what it is made for lol). Has anyone had problems with it growing too large?

Genius :D Pefrect, Works like a charm Thanks again RuralGuy

Thank-you It is working great now. Right now when i select a model # from the combo box it displays the corresponding tab which is exactly what I wanted. Just out of curiosity is there a way to have those tabs change when previous records are selected and viewed aswell? It seems that after the...

still tryin I would like to try RuralGuy's suggestion first because it seems the fastest. Where do I enter: Me.YourTabControlName = 1 ? I cant get it to work

I was wondering if anyone could let me know how to do the following: I have a form with a subform in it. I based the subform on a combo box that gets its info from a table seperate from the form(This works fine) when an item is selected from the combo box it retrieves the correct subform...