Search results for query: *

I have an excel spreadsheet. The first two lines are duplicates, except for a FROM DATE. So, 4 columns are the same, but the 5th column (from date column) is different. The 6th column is an empty field (Thru date). It looks like this: Col A Col B Col C Col D From Date Thru Date...

I'm looking to figure out how to populate a cel with the previous cel data, IF the current cel is blank. Column A Column B Column C Test A Test A Test A Test A Test A Test B Test B Test B Test B Test B Test B Test B Test B Test B Test C Test C Test C Test C Test C So the empty field under...

I have a form where the user can select a combo box which will filter the records that are brought back. However, I receive the error: "Run time error 3075 - Syntax error (missing operator) in query expression 'tblissues.issueID is >0 and Region = 'CO"." Here is my code: strSQL = "" strSQL =...

Hey everyone. I have a subform that is based off a query, so I can perform a "keyword" search. The criteria in the query for that particular field is: Like "*" & [forms]![SEARCHfrmGlossary].[txtKeywordSearch] & "*" When I run that form by itself, it's fine. But when I add that form as a...

Hello. I'm using a tab control setup on my Access form. The only problem, is that with 2003, you can't "colorize" the tabs so the user can know exactly which one they are using (if you can, please let me know!). So, I would like to have a text box that displays the name of the tab the user is...

Hope everyone had a good July 4th! My issue is this: When I open a table in MS Access(linked table), all the data looks fine. However, when I create a query with that table, and enter criteria to search for, my results show up as (#DELETED)?? I'm lost as to why that is happening. Any ideas?

Hey everyone...In EXCEL, how would I write code for a specific cel? Say if someone clicked on cel A:1, I want to have a msgbox appear....Or if a value in a cel was wrong, a msgbox appear for that as well.... thanks.

I have a report that displays a lot of data. When I check the table for a particular record, on ONE line of the record, it has about 20 "lines" of information. (It's a "long" line of individual users). However, when I base my report off the query, it only displays 1/2 the users. The field in...

I have a txt file that I need to import into access. The problem, is that the quotes in the text file are causing the issue. The txt file looks like this: (sorry for the length) .BROEFS2_TEAMS2_ADMIN_RW.GROUPS.LAO.NA.CAPGROUP, "CSSC.GCAT.CGTC.LAO.NA.CAPGROUP DAK.GCAT.CGTC.LAO.NA.CAPGROUP...

There is a user who has 2 monitors on his desktop. He'll drag the access app (form) to one of the monitors. If he makes any selection on that form, the access form then jumps back to the first monitor he had it on...make sense? If so, how is this prevented? Or is this a user computer issue...

I have a form, which originally had 10 checkboxes. Each box was named: box1, box2 etc. I had a function that if the check box was checked, it counted (box = box +1). Then it gave a percentage (because there were only 10 boxes, it would be for example: final box count / 10 for the percentage...

Hi there... hope everyone had a great holiday! I have a form that is used for data entry. There are 3 combo's which are Company, SubCompany, Department. They are all in relation to each other. (Pick one, the other combo requeries...) However, there might be a time when the user wants to add...

I have a function: fOSUserName This grabs the current user name. I want to store that username in a table along with the date, so I know immediately, who is in the database incase I have to have them log out. And when they log out, the table should be updated with the date and time of logging...

I have a combo box that is based on a table with two columns. I have a subform, that when I click a command button, I would like it to populate the two fields on my subform, with the selected info from the Combo Box. It works with the first column: on click event: FieldA = me.combobox (not...

I'm sure this is a simple question...I've looked on these forums and so far no luck. All I want to do is export an access report to a word doc file. I would like to give the user the option to choose which they would like to do...view/print/send to word... There is an "export" option, but my...

Does anyone know or have any code so when the user clicks a command, it will "compact and repair" the DB? I ask this, because we are running this off a server, so If I have this set to "compact" on close, it takes forever. So I would like to do this on a "user" basis... thanks.

Hey everyone...I think I've reached my breaking point and I'm hoping someone can assist me. My Access is crashing now. I add a command button, save it. I add the label to it, save it. But when I run it, I get the "not enough memory..." error, then access crashes, and I can no longer access...

I have a form that contains multiple tabs (Tab control option). I also have fields that are not apart of those tabs (on another part of the form). I want to bring those fields into the tabs, but I have to delete them off my form first, then re-add them to the tabs. Is there a way to do this...

Hey guys. We are currently using a program called Linksfix (or something like that). It is supposed to correct any broken links in a lot of programs. It should do it for Access, but the support guy says it might not be supported yet for modules. Is there a way or another program that will do...

We have an excel file that is placed on a shared folder. When this file is placed on your desktop, and saved as a different name ("un-shared") the file size decreases drastically, yet it's the same file. Why is it that an excel file is so large when on a shared drive? It went from 16mb file...