The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
13 views

Text Compare in Excel [migrated]

I need to compare two cell strings with text content. i tried, =FIND() and VBA like function. Also i played around with substitute and LEFT(), RIHT() to get to a common ground. However I cant apply ...
0
votes
1answer
29 views

Which version of VB does MS Access use?

Which version of VB does MS Access use in the code editor? Is it VBA, VB.Net, other? I sometimes get confused when searching for help/solutions. For instance, in Access, you can't do: Dim s as ...
1
vote
1answer
113 views

MS Access query-by-form opening query, but not running it with new form data

I have created a query-by-form in MS Access. The form has a text field for each field in my table. I'm only using one starting out to test. The query criteria for that field is Like "*" & ...
0
votes
2answers
68 views

How do I translate this query from MS Access into SQL Server

How do I translate this into SQL Server: select -Sum((12=[GroupNum])*[BoardStatus]) AS G12 FROM QryAllBoardsByPacketIDs INNER JOIN tBsReportGroups ON ...
1
vote
1answer
168 views

VBA @ Access on replacing values on a huge list

I have a question (that's why I'm here actually :P ) about VBA @ MS Access. So, I have a huge database (well, for me it is huge, about 23K+ ID) on shoes. It has 5 columns: ID, Article number, size ...
0
votes
0answers
110 views

Ms Access lock a field based on its current value in datasheet

I have a check box named post in a datasheet i want it to be automatically disabled i.e. locked if post=true while the rest of the post in the datasheet which are post=false remained enabled i.e. ...
0
votes
0answers
14 views

Is it possible to have 1 piece of code do Global Error Catching in Access 2007 VBA

I know I can use code like On Error Goto ErrorHandler: in individual subs for error catching but I was wondering if there was a way for me to place just one "On Error" somewhere in my VBA code that ...
-1
votes
1answer
29 views

Grouped Data tracking [closed]

I have a MS Access Database that tracks clients, client regions and transaction types. Users are keying in transactions and once done, the system needs to create letters to the client regions ...
0
votes
1answer
95 views

Calculating Open Days field and stopping with status change

I had a question but wasn't sure where I needed to post or view if someone has done this before. I have a dilemma on my hands. Background Info: I have been trying to figure out what to do since I ...
0
votes
1answer
671 views

VBA Maximize Access Application Main Window

I need my access application window to open up in full screen. I have tried using: DoCmd.RunCommand acCmdAppMaximize and DoCmd.Maximize (which I think only maximizes a Form). Neither is working ...
3
votes
2answers
285 views

Rearranging Data in an MS Access 2007 table into a new table format/Result Output

I have Access tables that have the following format: -------------------------------------- |Name |Math|Science|Reading|Civics| -------------------------------------- |Mike | A | C | A | B ...