Search results

Hello, I have a main table that has a field that is linked to sub table (using lookup, set row source to correct table using SELECT statement that selects two columns out of the sub table (e.g. the ID and Name Column)). When I run a query on the main table I would like to be able to set the...

Hello, I am modifying an excising database for a acquaintance. now I have the following problem: The database consists of two tables (TblA and TblB) and two forms (FrmA and FrmB). One of the two forms (FrmB) has a subform (SubA). Form A is used to populate data from table A using listbox and...

Hello, I use this class: http://www.lebans.com/listboxcolumnresize.htm to autosize the columns of my listbox. I use this listbox to populate data from my table using a textbox and a SQL statement. The problem is this code gives a error sometimes. The strange thing is I can't reproduce it. (the...

Hello, I've created a option group in my form. I've added some checkboxed into it using the control wizzard. Now I would like to add some more checkboxes to the option group. I can create them outside the option group and dragged it into it but when I run this code: For Each Control In...

Hello, I've got this code: Dim FieldNames() As String Dim Rst As Recordset Dim f As Field Dim Counter As Integer Set Rst = CurrentDb.OpenRecordset("TblParts") Counter = 0 For Each f In Rst.Fields FieldNames(Counter) = f.Name Counter = Counter + 1 Next...

Hello, I am modifying an old Access database in Access 2007. The old database still has the old Access design. Is there a possibility to change the old design to the new design? Thanks in advance.

Hello, recently I've asked this question: http://www.access-programmers.co.uk/forums/showthread.php?t=177143 At the end it all got confusing. Thats why I'll try to give a better description of my problem. I have a form with a checkbox. The checkbox control source is linked to a field in the...

Hello, I am modifying an excising database for a acquaintance. now I have the following problem: The database consists of two tables (TblA and TblB) and two forms (FrmA and FrmB). One of the two forms has a subform (SubA). Form A is used to populate data from table A using listbox and a...

Hello, I have a lot of problems accessing this site. Sometimes I can open the site : http://www.access-programmers.co.uk but the forum section will not open. When I start a new thread or reply on an excising one and I want to submit is it takes a long time before the thread is shown within my...

Hello, I have a data-table that is filled with data (is logical :)). I use a search form to populate data from this table into a listbox. At the moment I have two combo-boxes (one for the column to search in and one for the column to order on). I use a textbox (sText) to enter a search string...

Hello, I have a data-table. Using a search-form (FrmSearch) I populate data in a listbox (in the search-form). When a user double clicks a row in the listbox a new form (FrmEditNewRecord) is opened to edit the row. On the search-form is also a button where a new record can be created...

Hello, I want to use a checkbox to let a uses choose between "yes" and "no" In my data table I would like to display this as something else. For example: Coffee, Tea. I try to accomplish this the following way: I have a checkbox and a hidden textbox (source control is linked to the right...

Hello, I have some strange things going on in my table. I have records 1 to 152 in my data table filled with data. When I add a new record the ID starts with 54917764 instead of 153? Is there a way to initialize the ID this or is this a error? Thanks in advance.

Hello, I use this code to populate data from a table into a listbox. Public Sub PullData() 'Purpose: to refresh the contents of the list box based on the text entered into the TxtCriteria control On Error Resume Next Dim StrSql As String 'SQL statement for the record source...

Hello, I have a form that searches a table with 8 columns. The data that meets the search criteria are shown in a list box. I would like to make a report of the list box content. I've tried a lot of ways to bound the list box content to the report controls but still without success. What's...

Hello, I have a few text boxes filled with data from my data table. When I modify some of the data in the textbox I would like to store it into my data table (I know the record number of the record) What is the best VBA way to do this? I was hoping for something like this...

Hello, Probably a simple question: How can I select a text box that is located on another form? Within form A I use me.textbox1. But if I want to call this text box on form b this does not work? Thanks in advance.

Hello, I have a table filled with data (8 columns) and 500 records. I have made a search form ( with a lot of help from the forum users) that lists records that meets certain search criteria. When a row of the list box is clicked double ( I assume this is the double click event, but how do...

Hello, I have a search form that searches a table and shows the records that meet the search criteria in a list box. The problem is that the width of the list box columns can't be easy auto sized. I know it is in fact possible but this is rather difficult...

Hello, I am new on this forum and also new when it comes to Access. My goal is to make an inventory database in Access 2007. The database will consist of: 1. A table holding all the data (with 8 columns), and n rows (depends on the inventory. 2. A split form with a text box to enter a search...