Recent content by marcin2k

Ok got around it, changed the field to a string and it seemed to work fine with Cstr THanks for the ideas

Its a number field, i tried the IIF statement to check if its null and it does not do anything. ITs still displaying #Error inside the field ItemID since there is no record assoiciated to that specific order

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

Solved the issue, here is the function I put into an update query for that given field: Function UpdateRack(intOrder As Integer, intItemNum As Integer) As String Dim db As Database Dim rst As Recordset Dim strRack As String strRack = "" Set db = CurrentDb Set rst =...

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

Thanks, I made a slight change I noticed that if I checked if an files attribute = 6 Then i did not display it and it worked cause those ended up being the hidden files

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

Thanks for the help, adding & "" worked great

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 noticed that if I just use =[Forms]![fForm1]![EndDate] it does not even display all results with the same date but displays all records instead

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

Thanks for the help, I actually found a Picture Box for VBA that someone has coded. It has the same commands that a regular picture box has.

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

Ya that worked great, do u know by any chance if there is a one liner for changing one data field in a table. Like i know Dlookup looks up what is in a field but I have a table with one Yes/No field and all i have to do is change it to a No. I know i can use RecordSet but trying to think of...