Search results

That did the trick. Thanks - i'd have never found that on my own. You saved me a lot of time and frustration!

I am hoping someone smart can take a look at the attached database and help me figure out a riddle. There is a form (frmMain). Upon opening the form there is an option to select a series - then a color (select *Show All for color). Now you have an option to select the items in the subform to...

Thanks for the replies - I appreciate it. I agree that ideally these spaces would be a part of the data. Unfortunately I have to deal with linked tables fairly frequently. In this particular case it does look like the Trim Function is going to work for me. Thanks!

I am trying to figure out a good way to deal with a linked table that has some spaces at the end of the data, and how to query for that. What I have is data in a field that looks like this: A A+ B B+ C C+ All of the one digit records actually have a space, in the field, after the single digit...

Thanks for all of the replies. I was trying to avoid adding a lot of detail to this post, that's why I posted a basic request. There are many more fields to this table than are in the example database. I'm trying to accomplish something, and had an idea, which may or may not work. The table I...

Not sure what we are missing...? When I try to run the query: query4, it just displays: "you are about to update zero rows" I'm trying to update all field values to null, across the six fields in the table, except for filed values of CT

I tried both of the suggestions above. They did not work. I've attached a sample database, with the example table that I am trying to update. What I want is - for the six fields - update all records to null, in the six fields, except for records that are field value "CT"

Struggling with this: I have a table with six fields. I want to update the values in the six fields, in one fell swoop, if possible. The six fields contain two digit codes (record values), or they are null. What I want is: set all field values, across the six fields, to null, unless the value in...

That makes sense. I will give it a go

I have a query that is using a linked table for the data source. The query has a field that prompts the user to enter a warehouse code, to look up the records. The data on the source, or linked table, is all upper case. I found that if the user keys the warehouse code in lower case the query...

It looks like it was the file size. Kind of an odd thing, no error message or anything. It was just a single image on the report but, since it was actually labels it would need to print twenty instances of the image per page, one for each label. The original file size was 617 KB and it would...

Hello, This is not the Access 2016 issue, I have already come across that in a different scenario. This would be with the 2010 variety. It's simply a matter of the image not displaying on each label as it would be expected to. A couple things - I tried it as a bitmap and it works normally. I...

I have a report that is a label. It is designed to have two columns and ten rows of data. There is an image that is embedded on the report and should show up on each label. The image is a jpg. For some reason the image does not appear on each label. The image shows up on 11 of the twenty labels...

I think I figured out the last piece of the puzzle, I think this works for all possible scenarios. see attached - hope maybe this can help someone else. Thanks again Pyro for getting me over the main sticking point.

Hello, and thank you very much, this is pretty much what I was looking for. Figured there were many ways but I was stumped. I like your option using the union query and am adopting that one. One more hurdle that I am hoping to overcome. I have uploaded the newest version of the database. There...

I have attached an example database of something I am trying to create. In the database there is a form: frmPrintLabels. If you open the form there is a list box called Series, if you select a series it loads the optional colors for the series in another listbox. If you select a color it...

Thanks for the replies - let me test some of these ideas

Hello, Not sure if this is best posted in tables or not - so posting it here. I have a database that is used to create serialized stickers for inventory. I am using an auto-number field to give each record a unique serial number for labeling and barcoding. Currently to enter new records - prior...

Something I have never understood. If I have a report and it has controls (labels representing column titles) in the page header. Now when I print the report - if it happens that the last page has no detail records - but there is text boxes and so forth in the report footer. Is there a way to...

Figured it out - if it helps anyone else out: needed to be: dateout: CDate([Forms]![CheckOut]![dateout])