Search results

I have a field in a table that I'd like to extra the texts from. The are stored in below format (separated by colons). They don't always the same amount of characters and not all of them have the same amount of texts, some may only have Text1:Text2::, while some may have Text1:::Text4.

Sorry, super VB noob here... How do I create procedure so that when the mouse touches an object, such as a label or textbox, the object changes color? I want to be able to use this code for many objects in the form. Apparently, I can't do something like I get the "NullReferenceException was...

I have been an Access advocate for a long period of time. Although I do not have a programming background (at least educationally), I have managed to learn as I go with numerous applications I've developed. I am at a point that I want to get very serious about becoming a programmer and learn...

I have changed numerous features in "Current Database" under "Options", but I am unable to achieve what I need. I just need a popped form to show up when the program is initiated (no other background), meaning, I want to hide all the Runtime menu. I am able to get to the point of just the form...

I'd like to be able to see the values of all the global variables in runtime by clicking on a command button. I don't know if there's readily function for that. If there's no aforementioned function, how do I list out the variables in a message box with the below function I have already...

I want to build a command button to open a cash drawer without going through a printer. I learned the printer codes for this particular printer are 27,112,32,25. Can anyone help me with the VB codes to achieve this?

Needing help with syntax involving a number type variable and date () as conditions. Below does work for me.

I've read online that the ODBC connection to remote database is not secure, but I cannot find the exact reasons. Is it possible that hackers can intercept the data that is being passed? If so, what is the best way to make this connection secure?

I need help with dlookup based on two global string variable. Please help me fill in the ...........................

This question is related to a restaurant POS system design. Is there a way to allow a text field in a form to be filled by a scanner only, unless an event is triggered? Rather than using a magnetic strip ones for gift cards, we're thinking of using the bar code version. However, to prevent...

I don't know what's common practice, but I've been using functions to pass values to queries as criteria. I would often set a global variable from a dlookup function or from a record selected in a form, then I'd pass the value to a query. I'm not sure if this not a good practice or something...

Hi, I need help on the condition part of the dlookup function. Both conditions are based on variables, with one created using TempVars in Access 2010. Variable one: GstrID (a global variable) Variable two: Created by TempVars.Add "OrderType", strOrderType) So the function should like something...

It sure doesn't seem difficult, but I'm having a hard time with this. I basically want to select all data prior to a date that is entered from a form. The field is I'm sure I need to convert this or add "#" somewhere in the criteria of the query. I tried and many other syntax's, but none...

I have a query that has a criteria that is based on a function [PrintedFunc ()]. The field (Printed) is filtered by "Yes" or "No". The report filters fine when the function returns "Yes" or "No". What I need sometimes is to print all the records, whether the record is "Yes" or "No"...

How to apply multiple filters upon opening a form? I can set filter to one condition with the below code in the OnOpen event, but I actually need to apply the following conditions: [Status]="Open" and [OrderType] ="condition1" or "condition2" Me.Filter = "[Status] = 'Open' "...

I have small network setup between two computers and five receipt printers. I have .accdr front end on both computers with .accdb back end stored on Computer B. Computer A: Front end and a printer (Printer A) Computer B: Front end, back end and four printers (Printer A,B,C,D) I have gotten...

How to convert this string of text that is formatted yyyymmddhhnnss to hh:nn? I can do the mid function to extract the hhnn out, but have a hard time with the rest.

Hi, These buttons with SendKeys functions for page up and page down were working fine yesterday, but today, when they are pressed, the are changing the Num Lock. Very strange. Below are the codes I used for page up and page down. Has anyone experience this before or have any idea why this is...

I have a date field that stores time based on a calculation or based on what the user chooses from a combo box. I use a global variable to store that time and updates a table. At the end of the sequence, I set the variable to 0. In some occasions, the users do not have to choose the time...

Hi, I'm having a hard time figuring out the exact syntax for the below dlookup function. When I separate the criteria individually, I get a result, but when I combine the two, I get run-time error of Type Mismatch. strTableID is a string variable