Search results

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...

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...

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...

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...

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?

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...

Does anyone know how to run a requery and stay on the same record? It says to enter a Go To expression but I cant for the life of me find a good one. I published a thread almost like this yesterday and no one answered, I wonder if is really that hard to do??;) Thanks

Is it possible to put a "tag" (probably the wrong term) on individual record entries? So that on a shared database the administrator could see who entered what. That way if there is a problem the administrator would know who to speak to or who needs retraining/firing ha:) Ive looked around and...

:confused: Does anyone have any suggestions for literature (preferrably online and free, but not restricted to) on learning to code. I'm having problems locating a starting point. The help menu assumes you know what your doing and is no help for a beginner.

I was just wondering if any one had any tips or insider secrets on how to lower the size of a database and/or get it to run faster and more smoothly. I know you can split it but is there any other way? I'm using alot of macros and going from screen to screen there is sometimes a lag. I dont know...

I have a Form with a combo box that takes in formation from a table and auto fills it. But i cant get that autofilled info to enter into the main table.the one that the form is based off of. I tried to use an append query to move the info from one table to the other. It didnt work. does anyone...

I have a Form with a combo box that takes in formation from a table and auto fills it. But i cant get that autofilled info to enter into the main table.the one that the form is based off of. I tried to use an append query to move the info from one table to the other. It didnt work. does anyone...

I created a form from a table (maintbl) with a combo box. The combo box retreives information from another table (model#tbl)and autofills it in the fields below. the information that is autofilled does not automatically get entered into maintbl. Theres probably a good reason for this but i cant...

I have a Macro that I made to archive 4 different tables...using append queries and delete queries and attached the macro to a button on a form. I had to disable the warnings because there were just too many of them...i was wondering if there is a way to customize one warning (like: Are you sure...

Ok... I have notice that every body and their dog has asked this question and reading all the other posts has helped me along. However i have hit another roadblock. I know that IT IS possible to have a combo box that, when an item is selected, selected fields are automatically filled. Is it...