Looking for a way to remove trailing and leading blank spaces from fields on a form

Best Microsoft Access Programmer Portland OR

So ideally I would just be able to prevent the spaces in the fields from making it into the table by automatically not allowing them in the field on the form, however if I can’t how do I remove them in the table after the fact? Its just slightly annoying to have to go through 1000’s of records to find a ” ” which isn’t apparent at the end of an item. Albeit the spaces at the end don’t affect the database as much.

Read More

text box appear based on the table value

Best Microsoft Access Programmer Portland OR

I’ve put this ‘ =IIf([Stock Inventory],([Number of items in stock]>3,(“Low Stock – Re-order”) ‘ into the control source on the property sheet. but it keeps saying I’m missing a bracket, IDK where tho, when I put a bracket around the >3 it said it was an invalid syntax. I’m very confused here please help.

submitted by /u/tismail2
[link] [comments]

Microsoft Acess Developer Portland ORRead More

Creating a report with a multiple table query

Best Microsoft Access Programmer Portland OR

So i have a report I am working on, and I made a query with two different tables its pulling from. That worked out fine so far, but I have an issue where I want a specific tables set of data to print out, and then after that print the other tables data.

So right now I have Table A and Table B

It prints out: A B A B A B A B

but I want it to print out:

Read More

How to use macro builder to open form and pass selected list box value to that form

Best Microsoft Access Programmer Portland OR

I have a form which includes a list box

The list box has bunch of records

I created a detail form that I want to open when I click on one record in the list box.

The challenge that I have is when I go to Macro Builder for the On Dbl Click event I cannot figure out how to extract the ID value of currently selected row in the list box that I just clicked.

What exactly I need to put in the

Read More

VBA for MS Access front end to connect to Linked SQL Table.

Best Microsoft Access Programmer Portland OR

When I run an Access Query that pulls from a Linked SQL Table, I’m prompted for a password. How can I use VBA to avoid that blasted sign in prompt.?! I have looked into ADO but not clear. I don’t want a recordset object. I want to establish a connection, then use a docmd to run a query on the linked table. Thanks!

submitted by /u/XxMercerxX
[link] [comments]

Microsoft Acess Developer Portland ORRead More

VBA for MS Access front end to connect to Linked SQL Table.

Best Microsoft Access Programmer Portland OR

When I run an Access Query that pulls from a Linked SQL Table, I’m prompted for a password. How can I use VBA to avoid that blasted sign in prompt.?! I have looked into ADO but not clear. I don’t want a recordset object. I want to establish a connection, then use a docmd to run a query on the linked table. Thanks!

submitted by /u/XxMercerxX
[link] [comments]

Microsoft Acess Developer Portland ORRead More

Press Play: Music News for the Week of December 13

Best Microsoft Access Programmer Portland OR

Press Play: Music News for the Week of December 13
by Robert Ham

Lauren K Newman
Lauren K Newman courtesy of the artist

Hello, you fools. We love you. C’mon join the joyride. It’s time for another edition of Press Play, our weekly roundup of Portland-centric music news. But first up, let’s pour a little out for Marie Fredriksson, the singer for Swedish pop geniuses Roxette, who passed away after a long battle with cancer at the age of 61. RIP.


Last week, we reported on the death of Lauren K. Newman, the artist who … Read More

The 19 Best Things to Do in Portland This Week: Dec 23-26

Best Microsoft Access Programmer Portland OR

by Mercury EverOut Staff

While this maybe seems like the answer to a dumb question (“Whaddya mean ‘what is there to do this week? CHRISTMAS is what you do this week!'”) you might be surprised at what else a week can be even when there’s a Christmas smack in the middle of it. There’s some funk (DâM Funk, to be precise), there’s some basketball, there’s even some Liberace and Liza (!?) on the menu, and that’s not counting the veritable feast of movies and … Read More

Page 1 of 367
1 2 3 367