Search Result

Hello.

I am trying to change a RecordSource (query) of a subform based on user selection in another form.

In the code below I am setting the same query as defined on the subform (Property RecordSource), but it returns no records at all.

...

I am currently working on a project where I am using a bar code scanner that enables people to scan their employee ID and another bar code from a piece of paper. The scanner scans the code to a text box that has focus. However afterwards the text box loses focus and I can't set the focus to the text box in its lostfocus() event.

Any ideas how to do this?

I am working with Microsoft Access 2003.

Any help...

Hello,

I have a form that is locked by default, if a user wants to make an edit they have to hit the unlock button. I want to display a label to let them know the form is locked at the top, so new users don't assume it doesn't work.

My logic is: The unlock button has a method where it enable edits to the form once clicked. My code based on that is as follows;

...

Hello,

I am new to VB&Access and inherited a project. I have a form with multiple buttons and if one is clicked then a few fields under the buttons are highlighted. Different fields are selected/highlighted depending on what button I click. I have managed to write VB code to throw up and error if a field is null, but that doesn't help me much because on a different button click that field might not need to be filled in.
...

I have a login form that I am using to direct particular people to a customized switchboard. All of the login process is working perfectly. (I am not doing this for security but for simplicity, so there is no concern about the faults of VBA for security.)

What I need is to get an unbound text control on the formSwitchboard to lookup the EID that was entered on the login form. How can I do this?

Thank you in advance!

Hey guys,
i have been having trouble getting started with a visual basic 2008 project. I happen to be reasonably new to visual basic and am finding that it is more difficult to work out solutions than it is using javascript or php within web programming.

Anyway the project that i am working on is a small piece of software that can search different tables in a Microsoft Access 2003-2007 Database depending on the selection criteria...

First, let me say that VBA is not my strong point but I have been bestowed with creating a duplicate database of a former employee who sabotaged the original. And everyday this isn't working is creating a ton of manual work for other people. I have managed to get the entire database working with the exception of the final step.

Basically, you click three buttons, the first button imports many text files using the Open File Dialog...

Okay so here's situation. I have an Access 2003 Report that builds off of a Query which pulls from a Table which is populated by a form... The data is the employee (name), the hours they worked for the day, and the project they worked. I have a Start Date and and End Date Parameter set up. I am trying to create a Weekly and a Monthly Report for cost. I need it(query maybe?) to add up all the hours worked by that employee, calculate the overtime...

Hello all,

I have been having some troubles figuring out how to do this. Naturally, I have looked through this forum and countless others, all yielding the same answers to my question... which for some reason I cannot get to work. I can't quite figure out what I'm doing wrong here.

I am in the process of creating a search form that searches through a database using different parameters. This parameters are text boxes....

Ok say i have a form pulling from a table(call is table A)
and the first combo box hold an integer that is a auto number starting at 1 (which in this case is the same number as the current record I'm in)
what i would like to do is run a query in another combo box on the same form which would look something like

Select ID
From Table1, table 2
Where Table1.ID = Table2.id

My problem with this...

Hello Bytes,

I am very new at using Microsoft Access and have just recently implicated it in recording productivity on outbound calls for my team.

My team is in charge of making outbound calls to agents to verify insurance on people's loans. We make a first call, and if it is not solved we will make a second call.

At the end of the day, we are required to send our totals in to workforce management to calculate...

I am trying to create a database that list materials and their quantities, and highlights quantities that come up outside a certain percentage range against the average. I have tried the following conditional formatting:

Condition 1: [quantity]>Avg([quantity])*1.5;
Condition 2: [quantity]<Avg([quantity])*0.5

However, there are a lot of different materials that differ in quantity, and what the report is...

Hello,

I have a microsoft access file with fields that have "long binary data". I would like keep the same file, but change the "long binary data" into regular text. There are a large number of fields, so it needs to automated. I'm not a programmer, but a network engineer. Is there any way to do this without programming? Thank you, Ken

I noticed a thread (now closed) asking how to use an array as a source for an Access report, for which no useful answer was given, and the guy gave up and put the data into a table. I also didn't find any useful hits on Google, so I decided to figure it out for myself. I applogize to the closed thread questioner for being nearly 5 years late in offering a solution.

1) Leave the RecordSource property blank
2) Create your controls...

Hi,
I have text files that are created with comma-delimited records inside them. I am trying to figure out how I can construct a command-line method of importing the records to a MSA table. The end result will be that I can right-click on the .txt file, there will be an option on the context menu that says something like "Add records to 'Modules' table", and that will bring up a command window that will execute the import command....