Recent content by elfranzen

I have searched high and low for sending a simple UDP command. It looks like it might have been possible with older versions of access but the newer version maybe not. Does anyone have any info on sending a simple UDP command via VBA. I just want to take a number from a query and broadcast it...

Never mind you were right now it is working. thank you very much

Where ((dbo_BB_REVENUE.DaysOnLine)<IIf(([forms]![Report Form]![Check209]=-1),[forms]![Report Form]![Combo201],999999)) my Where state is very large but I took everything else out just to show you this part but I changed it around like this. and it still doesn't work. I guess I am not getting...

OK I finished out the IIF statement and it still doesn't work. IIf(([forms]![Report Form]![Check209]=-1),<[forms]![Report Form]![Combo201],<999999) IIf(([forms]![Report Form]![Check209]=-1) Returns if check-box is checked or not in a form <[forms]![Report Form]![Combo201] this pulls a number...

I am trying to filter a query where if a check box is true then it will us this code. I haven't put in the false part yet because I can't get the true part to work. I have put the true part in the true and false part of the IIF statement and it still doesn't but if I take out the IIF statement...

while I was waiting I was still trying things and this is what I came up with that worked in the combo box all = * then i put Like [forms]![report form]![combo58] that way it would just return the wildcard and select them both.

Here is what I have in my Query IIf([Forms]![Report Form]![Combo56]=0,1 or 3,[Forms]![Report Form]![Combo56]) in the combo box I have it setup like this Yes = 1 No = 3 All = 0 it is pulling for a SQL database and what I am looking to do is if they want them all select 1 and 3 but when I save...

I am looking for code to send UDP commands in VBA. I need to send "Promo" Binary 0) 0 1 0 1 0 0 0 0 1) 0 1 1 1 0 0 1 0 2) 0 1 1 0 1 1 1 1 3) 0 1 1 0 1 1 0 1 4) 0 1 1 0 1 1 1 1 I would like to see code let lets me use the "Promo" instead of the binary string if it is possible. I have a...

it is a SQL database. I am not able to work directly in the SQL server due to some regulations and other stuff. that is why I am using Access. they seem to be fine with this type of connection as I am very careful to only read data from the tables and I always test my stuff to a backup database...

OK this is what I am trying to do. I have some digital signs that play different videos. these controllers can listen for UDP command Via Ethernet. what I would like to do is use access to start at a certain time. (I know how to do this) and connect to a SQL when the database is updated with...

Got it Thanks so Much works great.

I am looking to build a report that pulls data from one table but I need to compare data that is I week apart. the tables logs this data every 15 mins in to 10 seperate groups. I need to match the time but be 1 week off. so if I am pulling field 1 I need to pull this field twice once at...

OK I have tried the code out of the VBA help screen and I keep getting this Error "Run-time error '1004': Method 'HasRoutingSlip' of object'_workbook' failed this is the code I am using from a button Sub Route() Workbooks("BOOK1.XLS").HasRoutingSlip = True With...

We use integrisign I saw an activex control for it. I am a little rusty on Activex controls. I wonder if I can look at the sample Database an convert it over to work with our pads.

I need to capture a signature field from a digital signature pad. we use them all the time for Excel docs. has anyone used something like this before in access.