Microsoft Access / VBA Forum

Can someone help. I'm afraid I'm not too good at Access. What I'm trying to do is create a main form with a subform. The subform is "Search by Item Desc", which the record source is a query called "Item Desc". I want to have 2 fields in the header.......Item Desc and Part Number, where you can enter an item desc, such as "Specials" and...

Hello, I am creating a database that will be used to keep track part numbers being assigned to new parts. The main table (tblServPartNbrLog) has a part number field. This is a text field and is 12 characters in lenght. I have another table called available part numbers with has all the remaining part numbers allocated to this project listed...

I have two tables with words. First table has 2 fields: German, Croatian. Second table has 2 fields: German, English. First table in the German field miss attributes (der, die, das), (pl). This attributes is only for nouns, not for vers... Second table (German field) HAS that attributes, but this table is much bigger then first table....

I have 2 forms, an unbound which calls a bound form via a command button. Both forms have a textbox called TDate. The name of the calling form is SelectionFrm. When I set the DefaultValue property of the textbox on the called form to: =!! I get exactly what I want in TDate on the called form. But if I remove this from the properties...

Just updated my Access 97 db front end to Access 2003. When I open my linked table manager, it's empty and I have several linked sql tables and access tables located elsewhere on the network. I've updated several of these db front ends and the linked table manager has always been populated... This last one isn;t. Any thoughts??

Hello All, I'm making an access version of an old Q&A Database. There is a report in there that I'm having problems with. It involves Account types and Months. Ex.

I was looking in the Samples folder for MS Office10 and saw the following files: Analyze sales.htm Employees.htm Review Orders.htm Review Products.htm Sales.htm Where are these files used and what is used to create files like these?

Hi I'm using a database based on the Contacts wizard. My query is about the 'contact types' field. I need to be able to add more than one contact type for each record - maybe three or four (because I'm listing each contact's skills) - and I also need to able to search through 'contact types' taking into account all the categories. I'd...

I have a Customer Service database with over 70,000 customers in it. I have Normalized the whole thing. When a Customer Calls in, a Customer Service Representative looks up their record, and it contains all the customer's information. In the last few weeks, it has been taking longer and longer for the records to be found. I have index all...

From time to time, I randomly receive "Can't updated, Currently locked" error 3218 or 3246 from the following code in one of my form with pessimistic lock for 70 users environment. Any problem with the code? Private Sub Save_Record_Click() Dim stSQL As String Dim rs As Object Set rs = CreateObject("ADODB.Recordset")

I currently have a query that calculates the avg job time it takes an employee to complete a job. I would like to rank the results. For example, if I have 5 employees that complete Job 1 I would want to give the employee with the fastest avg job time a ranking of 1. Any suggestions on how I would do this?? Thanks

I am having trouble running queries. I select the fields I want to show up in the query, but they show up along with the rest of the fields. What am I doing wrong?

Dear all, I have a contacts table (table1) detailing ID First Name Last Name I have another table (table2) with a combo detailing the ID, First Name and Last Name i.e.

Hi friends I need routines to create an excel file with worksheets for each customer and a text file as well for each customer, first worksheet would be a "Summary Report", here is the code that would get the data for me I would appreciate if someone can add routines to create excel and text files to it, the columns in text file need to be...

How do you combine values in a report, for instance: How do you get: 1 Bacardi Gold 1 Bacardi Gold 1 Bacardi Gold To Read: 3 Bacardi Gold

Is it possible to limit the number of Subform records using MS Access 2003? That is, my end users want the capability of entering up to 12 records on their subform. Is that possible? Thanks!,

Hi, I am trying to do something really simple, but am not quite sure how to. If I have 2 text boxes on a report and I wish to hide one dependent on what the other is showing. i.e, Text Box 1 shows "Fred", Text Box 2 shows "Apples"

I am using MS Access to index documents (in this case material safety data sheets), to track what departments they are used in, and to allow users to browse the actual documents that meet some search criteria that they have entered. The documents are indexed, linked, and kept in a special directory. I have been asked to also provide a hard...

I am trying to pull all the records that have a payment due in the next calendar month. Pulling all October dates, for example works fine but when I pull December the year does no increment. What am I doing wrong? Thanks

getting, error, 3075 Syntax Error (Missing Operator) in query expression '8WHERE .=1' Dim TotalQty As Integer TotalQty = DLookup("", "", "=" & Forms!!) If (TotalQty - ) < 8 Then

Hi I am trying to create a database. I decided to split some of the information into two tables (not sure if this is best idea), as some entries may have these extra information some not. Example: asset table has information about certain attributes of asset. system info table has specific information which not all assets will have.

I have an Access form and I will be selecting multiple values from a list box. I would like to loop through the list box with a For Next inserting the selected values associated with there respective autonumber into an Access table. Here is my list box code: Private Sub Form_Open(Cancel As Integer) lstFilterContactType.RowSourceType =...

We urgently require following skill set HP Non-Stop servers, BASE24 applications Please send the cv to isoft_staffATyahoo.com / isoft_staff@ yahoo. com