Search results for query: *

I have created a table with names and address of customers in it. I have their firstname and lastname but want to create labels. How can I get only the first letter of their firstname and lastname to I can either store it in a field in the table when new people are entered etc., so I can pick it...

Hello. I have 2 databases in the same directory. One has a linked table. Everytime I need open the one with the linked table I have to go to the linked table manager. I would like to avoid using the manager; is there a way to do it with just one button click? DB1 c:\inventory\inventory1 DB2...

Can someone help me and tell me what is wrong with this code?: dbs.Execute " INSERT INTO Pagar ( Factura, Bodega, item, Cantidad, Monto )" _ & " SELECT Facturas.FacturaID, Factura2.Bodega, Factura2.item, Sum(Factura2.Cantidad) AS SumOfCantidad, Sum(Factura2.Monto) AS SumOfMonto " _ & " FROM...

Hello friends: I made an order entry application 2 years ago. The orders ship by week number. The problem is the following: If I enter 12/31/2009 happens to be week 53 but if I enter 01/01/2010 happens to be week 1? I have 2 printer calendars that show week 53 from 12/12/2009 to 01/01/2010. This...

I made a small application at work, some people use it and I do not want anybody to take the application with them when they change of job .How can I prevent someone to run it in a different computer? Thanks

Hello friends: How can I get this to work: I have 1 table with 3 fields:PlantID,SizeID,PriceID There are different combinations: Plant: 01 02 03 04 Size: Small Medium Big Tree Price:(Depends on the combiantion Plant/Size 01 Small = 0.23 01 Big = 2.00 or 02 Big = 2.20 02 Tree = 45.00 I...

Hi. I need to know how can I avoid a record to be included twice from a form. Thanks for your time.

Hi all. I need to know how I can run a query as many times as I need. Let's say I have a form where I have the following fields: [employee][timesabscent][cost] I would need to run the query all times as [timesabscent] shows. Is this possible? Thanks for your help. Roger Arce

I have a report that I generate from a query. This query has a yes/no value. There is a field that I need to hide if the yes/no is false. This field that I want to hide will always have data. Can someone help me to resolve this? Thanks in advanced. Roger

I have a form called myform, there is a subform in the same form called mysubfom. In my report I get information calling a query. Now, myform has some information that I pass to the report using: [Forms]![myform]![Product] My problem is that I can not get information from the subform...

Hi. I have this on Excel: =DATEDIF(C9,C10,"y")&" Years, "& DATEDIF(C9,C10,"ym")& " Months, " & DATEDIF(C9,C10,"md") & " Days" C9 = date1 c10 = date2 I was wondering how to make this formula using DateDiff in access? Is this...

I was wondering if there's a chance that I can read the hard disk' serial number with ms access? I would like to use it as security. Thank you for your help! Roger

I have a table called TblProducts with the following fields: ProductID Description an PricePerUnit I have a form where I input what is bought with the following fields ProductID units pricePerUnit How can I make the TblProducts update the price of the product when the price I input is...

I have a subform called SubFrmSoldCarParts and I would like to repeat the Parts [Brand] field with out type the same every record. This filed repeats a lot. the [Brand] field is a combo box. Thanks in advance, Roger (excuse my english)

I have a table called tblcars with the following fields: car,model,price and tax. I made a form from it with the same fields, except that label TAX in the form is calculated and has the following formula: =iif([MODEL]>=A,[PRICE]*0.005,iif([MODEL]<=B,[PRICE]*0.0010)) MODEL could be form A to Z...

I have a query that creates a table. I have a subform linked to this table. The form where I have this subform has a sum field. The problem is that when this subform does not have information and does not display any value or field, I get a #error message where I needed to be a zero value at...

I have a report from a crosstab query. After I made the report I included the paramenter in the crosstab. The problem is that the report prompts twice for the parameter. What could it be? Thanks in advance for your reply, Roger

I have a crosstab query for orders. In the crosstab I have the following fields: Customer Product Size Ship Week Year To get my information I have some criterias. The problem I have is in the ship week parameter. The criteria I use is: Between [Starting ship week] And [Ending ship week], if I...

I made my own tool bar but I want to totally hide the menu bar. I unchecked the menu bar to hide it but after I reopen the database it is there again. How can I solve this? Thanks in advance for you help Roger

Hi. I was wondering if I can change numbers to words in a report. Thanks for your help