Search results for query: *

Hello, I have two tables that I am combining in a query and grouping the data. Table1: OrderID Table2: OrderID OrderDesc ItemID ItemDesc My query has a relationship set up so that it displays all records from Table1 and only those...

I have two tables with a one to many relationship Table1: OrderNum Table2: OrderNum ItemNum ItemNum RackDesc RackDesc Table2 is populated automatically when someone scans a barcode for an order and a rack. I need to move that...

I am able to display all files from a folder into a listbox but I want to make it so that system or hidden files do not show up. How can i do this. Here is my code to display the files: Private Sub GetDir(sDrive As String) On Error Resume Next Dim strRowSource As String Dim crt Dim...

I have two combo boxes and one is suppose to limit the records based on the other. So if I choose in my combo box called Combo1 "Red" I want to see all records which show something like "Red" in one of my fields called Field1. HEre is what I have now. Field1: Like...

I have a query which has a field with a date (date type field). In the criteria I have put this statement: <=[Forms]![fForm1]![EndDate] EndDate is a calendar function. The problem is: For example if I pick the end date to be August 31st, 2005. It displays everything find except it does not...

I have a string with a bunch of x and y coordinates. I was wondering is there anything in Access like there is a picture box in Visual Basic for CE so that I can just write Object.Line coordinates or Object.DrawLine coordinates I noticed I can do this on a report, but I need to do it on a form...

Hello, I am trying to decode a picture which I have x and y coordinates of lines. I am do this in Visual Basic 2005 since it has an option for a Picture Box and I use the .Line command to draw a bunch of lines which make up my picture. Is there any thing in Access that I can use which will...

I have a variable datDate which stores a date and time, so its basically in the format of Now(). I want to check that this time is within 1 hour. How can I do this. I read about the DateAdd function but it seems to always give back a huge number when i subtract Now() from datDate. Thanks for...

I want to be able to open up a HTM file in my internet explorer on a click of a command button. Lets say my path is "C:\test.htm" Thanks for the help, its probably a one liner that i don't know about yet.

Hello, I am trying to make a summary table. I have a table with a bunch of data that contains like over 100 records for a single day. I am making a query to display the max and min temperatures for each day. Thats easy because I group by day and then use max and min but the tricky part is, How...

I have a query that populates my combobox. But if no results are returned instead of leaving the combobox empty I want to set it to display something that I will pick. Thanks Marcin

I have a contiuous form that works on a table. Basically its used to fill the table. I want to make it so that when a new record is made in the table the default text in it is what was in the previous record. Not sure if it is possible but I hope it is. This would save my people who enter data a...

I have a string I am changing around using Instr but I am not sure how would I specify this delimiter: It looks like a square, I think it works like an empty space any idea Thanks

I have an application where on my main form I have a subform acting on a table lets say called tTempItems. This subform is used so that people can add in as many items as they can. The table has the following fields: ItemID ItemNum ItemDesc Qty I need to make it so that as they fill each record...

Anyone know the difference between date and now(). I noticed that using Now() after noon gives a different date then using is before noon. Why is this? Thanks any help would be great.

here is my criteria so far, IIf(Nz([Forms]![fLAMPREditProd]![txtInt2ID],0)=0,Null,[Forms]![fLAMPREditProd]![txtInt2ID]) The False part of it works but whenever the txtInt2ID textbox is empty then the True part does not display Null records. It does not let me put "Is Null" because its a Number...

Hello, I am really lost, I am trying to think of a way I can make a user click a button and then basically a folder will open up and the user can select any file. When they select the file the path of that file will be saved in a textbox. Any ideas. Thanks Martin

I need someone to get me started, I have two tables: tCon: tTrans: ConID TransID EnvNo EnvNo Name Money Desc This is suppose to work like a bank account. I need to make a form with a subform so that I can type in an [EnvNo]...

Is it possible to enable a textbox on a subform when I choose an item from a combo box in my main form?

Hello, I have a command button that reads data from my scale, this process takes about 2 seconds so I would like to make it that the user cannot accidently click the button again until the code finishes executing or else it will give an error. I know that it does not allow the disable a button...