Search results

Update: gave up the idea of text boxed text, replaced with regular text and added a gray highlighter which essentially does all I'd needed for now. I'd ultimately like to protect that text, but will see where my draft goes from here. Somehow sharing it here made me want to try to go around...

Here's what I tried: Changed whole table to a different font (TNR): the difference in thickness was still apparent. Unbolded the text box headers (INTERVIEW INFORMATION and PUBLIC RECORDS in the image snippet): no change Removed the text box headers entirely: then the font appeared normal...

Hello all! I'm hoping someone can explain or commiserate. I'm roughing out some tables to be used for a rather busy set of data, so I made a table and added some controls to help automate it (autonumbering, some combo boxes, etc.) Because I have a lot of data to try to get onto each...

This is probably a dumb question, but has Access 2016 changed the game on creating a web-usable app? I ask this because I finally upgraded to Office 2016 recently at home, and they offer, under "New" to create a web app among their various templates which is different. They seem designed to be...

With embarrassment I admit I have forgotten how to do this.

Nice! It was the merging, but I'll keep this in mind for something else. Thanks!

That is exactly IT, thanks. I had received an Email of your earlier post, but was training an intern today and hadn't gotten back to it, but it occurred to me that it MUST be related to the merged column headers across three columns. It wasn't happening to anything to the left of D, so that...

Happy holidays, everyone! I've written a simple macro to do some autoformatting of an Excel spreadsheet. When I reduce to 100% zoom, I want to widen every third column so the contents display fully. Range("D:D,G:G,J:J,M:M,P:P,S:S,V:V,Y:Y").Select Selection.ColumnWidth = 2.1 When I run...

Thank you all for your thoughts and advice. There's a lot here to consider. I also asked my IT manager in-house, off the record, when we were discussing the recent job eliminations and so forth. He gave me some good input as well. I will refer back to this as I get out there and explore. Thanks...

Hello! I've visited the forums in the past to find information to help me out of a jam in Access or Excel, and have always found it very helpful. I'm a research director for local television stations in the U.S. When I started doing this work over 10 years ago, it seemed like there were always...

I just remembered that I'd asked about this. It turns out that the cause was my IT department putting me on a different version of Outlook than Excel. Since then I've been given a new PC with software that's more compatible. I just thought I'd mention this in case anyone else had the same issues.

This is probably something so obvious I'm hitting myself on the head in advance. Any idea why the button to "send worksheet as attachment" is not available in all workbooks lately? It always worked before. I checked Tools/Options but didn't see a setting for it. Thanks! -- Ann

It worked! Of course, I forgot the part where even some of the movie titles contained ampersands, so I still had to eyeball the results. But thanks again for the tip. : )

Thank you! I'll try that, but it makes sense, and I was just missing the understanding of how to put that together. Thank you for your reply. -- Ann

I have tried just adding the *&* to the query or or filter criteria, but it seems to parse it to "*" & "*". I have a list of television programs and wanted to be able to filter out the sports events, most of which are listed as "METS&CUBS" and so forth. I suppose I could do this manually in...

Okay, here's what I ended up doing... I ran an append query to make a separate file for the data with the "Sweep Date" criteria, adding the appropriate label in the Sweep field. Then I ran a delete query on the original table for data between the sweep dates. Finally I appended the new table...

Sure. In a separate table, I have three columns of data -- the label of the 'sweep' (in text, rather than data form), the start date, and the end date. In a simple access query, I paired the two tables based upon the criteria: WHERE Prime.Date >= Sweep Dates.StartDate AND Prime.Date <= Sweep...

<<If I understand you, all you want to do is tag the string "Feb02" to the end of the text field for the selected records. So if you have the records selected in a query then you can just use an update query to update the program name. >> No, not quite. I want to add the field "Feb02" to the...

I'm hoping to replace a manual text-add process in Excel to an update query in Access. I have one table of data (tracking ratings of TV programmes) with a date field. I have another table of data with the start dates and stop dates of TV ratings "sweep" periods (U.S.). In the past, I would...

It worked! I changed every non-numerical field in both tables to Allow Zero Length = Yes, and the append query worked beautifully. The funny thing is, I've never had that problem before when adding data. Maybe it just became an issue this time -- I'd have to comb the new data pretty carefully to...