python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - ms-access-2010

Is there a way to get a Bit field in SQL (non transact)

Let's say the field comes with a number like 134479872, I'd like it to revert back to 0xffffffff and extract each pair like Oxff00000, 0x00ff0000, 0x0000ff00 and 0x000000ff in a separate field. The bi...
test-img

VBSMartin

sql

ms-access

ms-access-2010

binary-data

Votes: 0

Answers: 1

Latest Answer

You could use the Hex$() function. ? Hex$(134479872) 8040000 To pad it to 8 characters: ? Right("00000000" & Hex$(134479872), 8) 08040000 But if you utilize the full 32 bits, you will ...
test-img

Andre

Formatting Mac Address in MS Access

New to MS Access. Had a question regarding formatting of a MAC Address in one of my Access forms. There is a field I have set up using an input mask aa:aa:aa:aa:aa:aa;;a where users can manually enter...
test-img

AAA

ms-access-2010

ms-access-2013

ms-access-2016

mac-address

Votes: 0

Answers: 1

Latest Answer

My function FormatMacAddress is for you: ' Formats a MAC address using one of the four de facto formats used widely. ' Thus, the format can and will be defined by the specified delimiter to use. ' The...
test-img

Gustav

Showing converted Hex/RGB color samples in a MS Access form with continuous rows

I am having a single ms access form with two unbound text boxes where I am showing two variants of PANTONE colors which are converted from Hex values to RGB (BGR) values in two public functions. I hav...
test-img

Lasse Staalung

vba

forms

function

ms-access-2010

converters

Votes: 0

Answers: 2

Latest Answer

Looks like you have the tough work done already with your custom color functions. I think you could easily solve this issue by adding the two color fields to your table - say TPX_COLOR and TCX_COLOR -...
test-img

dbmitch

Search between dates in an Access Query

I'm working on my capstone project where I'm making a database for a facility to log fall, abuse, and behavioral incidents. I want to give the user the ability to search by certain criteria in a date ...
test-img

award19

sql

ms-access-2010

Votes: 0

Answers: 2

Latest Answer

Between works for two dates Between (dateA and dateB). If you have additional ranged ,I sugguest using Where( Between(dateA and dateB) or Between(dateC and dateD) or....)
test-img

user14637347

Posts

Questions

Blogs

Jobs