Over 1 million tech questions and answers.

Access 2013 combo box not working on new workstation

Q: Access 2013 combo box not working on new workstation

Running a database, multi-user Access 2013, split backend, with 20 workstations/users
Got a new workstation (Lenovo Thinkstation P330)
Have it on a domain, all applications installed, no problems.

BUT, in our Access DB, and only on the new workstation, none of the combo boxes are working properly. On the new workstation, when you select a value in the combo box list, it will not update the corresponding text boxes. The form is populated by all the data from the first record, but a selection in the drop-down does not display. The rest of the forms, queries, reports, etc are all working fine on this new workstation. On all the other stations, our Access DB continues to work well, as it has for years, combo boxes and all.

On the new workstation, I have added the path to trusted locations.

I am feeling stupid and frustrated, what on earth am I missing?

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Access 2013 combo box not working on new workstation

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 69.2

Hello, Sorry if this is jumbled, I am helping a friend with there computer when they gave it to me they were unable to get into windows because there password didn't work. So I fixed that and got into windows and then I saw the root of the problem... TONS of malware and viruses. It wouldn't connect to the internet even. So the first step was booted in safemode with networking, used RKILL, then used TDSKILLER, after it found things( I don't have the logs sorry) I then was able to install and update MALWAREBYTES before this I couldn't get a connection after running TDSkiller i was able to get a connection but it would only hold for like 5 min at a time. So I installed MALWAREBYTES, updated it and ran a full scan which took 6hrs by the way which spent most of the time in a folder C:\Windows\SysWOW64\config\systemprofile\AppData\Local\Microsoft\WIndows\Temporyinternetfiles and same thing with the ending content.ie5....(byt the way I have never seen a folder scan this long) I scan my own computer all the time and it never does this)  I even went to look for this folder on here and the tempfilefolder isn't there or the content.ie5.... going on...SORRY. what Malwarebytes found I removed it was a lot of Zero Access and the Internet security2013. I then rebooted the computer. don't have this log either. I then ran malwarebytes rootkit and it also found stuff. removed them as well. I then ran superanti spyware it found about 29 items. removed them. and I then ran CCLEANER.. restar... Read more

A:Zero Access,Internet Security 2013,root Kits,SysWOW64 file combo dds log attach

Hi jillmarten and Welcome to BleepingComputer!I am currently looking though your logs and will advice you on what to do in my next reply.Please can you post the Attach.txt in your next reply so I can also review this.

Read other 31 answers
RELEVANCY SCORE 60.4

Hi All,
I have a combo box on a form header that I'd like to set up so the user can select a specific record to be displayed in the form. I have successfully set these up in the past, but recently I added a sub form that required me to change the Record Source of the form so it uses two tables, not one. Since then I noticed my Combo box no longer works. I've searched the internet for specifics on who to fix this but come up short! Any help would be immensely appreciated - I'm so close to finishing the project that I can spit on the finish line!
Here are the deets:
Main form is called: 'Update Employee Profile' --> Data accessed by this form is stored on table 'Employee Information' --> Primary Key is 'Crew ID'
Subform is called 'Company Issue Equipment' --> Data accessed by this form is stored on table 'Company Issue Equipment' --> Primary Key is 'Electronic Equipment ID' (one to one relationship to 'Crew ID')
Currently the record Source on the main form is:
SELECT [Employee Information].*, [Company Issue Equipment].*
FROM [Employee Information] INNER JOIN [Company Issue Equipment] ON [Employee Information].[Crew ID] = [Company Issue Equipment].[Electronic Equipment ID];
I'd like the combo box list to show the following headings: Last Name, First Name, Classification - all found on the 'Employee Information Table' . I currently have a query set up with ... Read more

A:Solved: ms access select record with combo box not working!

Read other 10 answers
RELEVANCY SCORE 60.4

Here's are the facts regarding my Access form:
- Combo Box "Segment" allows user to make a selection
- Combo Box "Fgroup" limits the user choices to only those applicable to the Segment they selected.
- I would like to display (for the user) a 2-column combo box with "Fgroup_ID" in column 1 and "Fgroup" in column 2. Only the "Fgroup" needs to be bound and stored in my underlying table. The "Fgroup_ID" is strictly there for informational purposes to assist the user in making their selection.

PROBLEM: I think the AfterUpdate on the Segment combo box is not recognizing both the Fgroup and Fgroup_ID columns. Can someone review this code and tell me what and where to insert the "Fgroup_ID" column information? I'm a rookie at writing code and appreciate any help I can get. I'm going to (try) to attach 2 printscreens of what the drop down list provides now, and what I would like it to
'After the user selects a Segment, it limits the list of Fgroups to only those applicable
'to the selected Segment.

Private Sub cboSEGMENT_AfterUpdate()
On Error Resume Next
cboFGROUP.RowSource = "Select tPRODUCT_FGROUP.FGROUP " & _
"FROM tPRODUCT_FGROUP " & _
"WHERE tPRODUCT_FGROUP.SEGMENT = '" & cboSEGMENT.Value & "' " & _
"ORDER BY tPRODUCT_FGROUP.FGROUP_ID;"

End Sub

'Allows the user to requery the list of Fgroup ... Read more

A:Access 2000 / AfterUpdate control not working for combo box

Have you set the Combo box's column count to 2?
Have you set the Column widths wide enough to display the data?
 

Read other 3 answers
RELEVANCY SCORE 60

After installing a QuickBooks update on a Windows 7 workstation, it required me to restart the computer, which I did. When it came back up Remote Desktop access was not (and still is not) available. This workstation is an Active Directory member. Remote
Desktop is controlled by Group Policy. I've run 'gpupdate /Force' on this workstation. There are 9 other such workstations in the office. All can be accessed via Remote Desktop except this one. I've verified that Remote Desktop access is enabled, "Allow
connections from computers running any version of remote Desktop ..." I've verified that Remote Desktop is enabled on the firewall. I've even turned off the firewall completely. This computer is able to access the network, the Internet and RDC to other
local workstations. It can ping other workstations, but other workstations cannot ping it. Nor can other workstations access this computer's shared drive. Network discovery and file and printer sharing are turned on. I've shutdown and restarted this workstation.
The error message when trying to connect to this computer is:
Remote Desktop can't connect to the remote computer for one of these reasons:

1) Remote access to the server is not enabled.
2) The remote computer is turned off.
3) The remote computer is not available on the network.

Make sure the remote computer is turned on and connected to the network, and that remote access is enabled.

In case there was some lurking update waiting for the nex... Read more

Read other answers
RELEVANCY SCORE 57.2

I am creating a database to track the courses an employee takes for the company. This will also be used for creating the registration list for a class being offered.

I have created the following tables: Accounts (name of business locations), Courses (name and course number of classes offered), Course schedule (dates of specific classes), employees (name, Account, etc of each employee), and registered students (the student id & schedule id). I believe my table set up removes redundancy, so I think I am OK up to here.

I am trying to create a form that will allow me to select an employee and based upon that populate the account field with the appropriate account name. If the employee moves to another account, then the account must be changed and the account id stored back in the Employee table.

I need to have the movement to a specific record done by selection of the name, not by entering a record number (or unique id).

I have tried forms and sub forms; I have tried macros using the SetValue expression, but I can't seem to get everything I need. Often I recieve a message stating that "The object doesnt contain the Automation object 'Test table 1'." It also says to "Check the components's documentation for information on the properties and methods it makes available for Automation operations." I have no idea what this is trying to tell me.

Any help you can provide will be greatly appreciated. Right now I am stumped
 

A:Solved: Access 2003 Updating a combo box using another combo box

Read other 10 answers
RELEVANCY SCORE 56.8

I am having the exact same problem as in the post "Solved: Can't find Access Query when using Word mail merge." I am using Office 365 so I have the newest versions of both Word and Access.

When I try to mail merge starting with Access (right click the query and export to word merge), it tells me it "Could not find file 'C:\Users\Jeanne\Documents\My Data Sources.mdb'" I have a folder called My Data Sources. And yes, the database I want it to go to is in that folder. Of course the folder doesn't have a .mdb after it. What file is it looking for and why? The Access database ends in .accdb. I found some hint somewhere that that might be a problem, but I can't find how to fix it.

When I start the merge from Word, it finds the database fine, but only tables are listed. The link mentioned in the other post is broken, so I can't check that out.

I feel like I'm saying to my son "I'll see you at home" and he says "I can't find the dog." What dog? We don't have a dog, and I never said anything about a dog!!!

I am getting thoroughly fed up with Access! I am fairly tech savvy and can teach myself to do just about anything in excel just through trial and error or looking it up online, but every little thing I try to do in access gives me all sorts of problems!
 

A:Solved: Access 2013 Query to Word 2013 Mail Merge

Read other 13 answers
RELEVANCY SCORE 51.2

How can I setup my access 2013 database Calendar to show up in Outlook 2013 Calendar. please help me

 

A:Link a Access 2013 database Calendar to Outlook 2013 Calendar

what database are you using?
 

Read other 3 answers
RELEVANCY SCORE 50.8

I tried to find a relevant thread but no luck..

I have a small network at home that consists of 2 laptops in the same workgroup accessing the cable modem/gateway wirelessly and 1 desktop in a different workgroup accessing via ethernet cable.

The laptops have printer and file sharing enabled so that my wife and I can share files....duh

My daughter uses the desktop exclusively and I want her to have internet connectivity (which she currently does) but I don't want her having any access to the laptops.

Will this setup prevent infection of the other 2 machines if she gets a virus/spyware or otherwise downloads something unsavory?

I don't know if it matters but we also have a network printer with a static IP that we all can access.

Thank you for your help
 

A:Solved: want internet access but no network access for 1 workstation

Read other 7 answers
RELEVANCY SCORE 50

Hi All,

I am trying to put a combo box on a form that will allow the user to both scroll through the list and start typing the first name of the employee to find the desired name. Clicking on the desired name would open the appropriate record.
So far, I have successfully created:

A 'multi column' combo box, that shows the information that I want, called "cboSelectBEP"
The combo box lives on a form called "Basic Employee Profile"
The combo box is fed from a query called "Basic Employee Profile Query"
All the main data is kept on a table called "Employee Information"
What I seem to be missing is the following functionality:

The combo box shows the test record (ie the list) when you click on the arrow but does not allow you to type the employee's name in to search
When you do click on the test record, it doesn't actually go to any record - other than the default record - btw - how can I change that so the form comes up blank?
I think part of the issue lies in the fact that my query takes the First & Last names from the "Employee Information" table and puts them together in a 'full name' format. I know the topic of comboboxes with 'search while type' functionality has been covered many times before but I've been searching the internet for 3 days and can't seem to find where I'm going wrong! Any help is appreciated!

To make it easier envision the situation with the... Read more

A:MS Access searchable combo box on form to access records

It is a property setting on the form that is causing the problem.
I have added a find combo to my form in your original database that works fine.
 

Read other 1 answers
RELEVANCY SCORE 50

Hello,

I have a Acer M1610 running windows vista 32 Bit and I downloaded the trial version of AVG Internet Security 2013. I have bought a license number and when I tried to enter it on the administrator account I received the following message.

C:\Program Files\AVG\AVG2013\avgcfgex.exe
Windows cannot access the specified device,path,or file. You may not have the appropriate permissions to access the item.
Access is denied.

Can anyone please help me fix this so I can enter the new license code.Any answers would be greatly appreciated.
Thank you.

A:AVG 2013-Windows cannot access the specified device,path,or file. You may not have the appropriate permissions to access the item.

I'd try downloading/installing it again...your package may be damaged.

Louis

Read other 2 answers
RELEVANCY SCORE 49.2

Well, gee whiz! I thought that I had all a soul could need fulfilled with my other two posts, but here I come again. I've only been a member for about 4 days and already I have asked 3 questions Please forgive me because I am slow

Okay...I have created a combo box that changes the data in the text boxes below. Very slick! Now, I've hit a snag. Let's say the combo box has the site - Denco - and the information that needs to be filled is address, phone, site #. This is done. Ok, so now, I need to look at Denco's ten employees individually, filling the second group of text boxes with their name, address, and phone. So, once Denco is selected, the address stuff drops in. Then, some sort of box (help me!) will show all Denco employees individually, then fill the other set of boxes with the info about the employees one by one (i.e. Beth, Pat, Ralph, Mike, Darrin). Does this make sense? If not, please ask, 'cause as I said, I need help.

Dreamboat has been here for the last two dilemmas, and if her plate is not too full, I hope she can help me again If not, I KNOW there are a wealth of people in this forum who can help and I thank you in advance.

Sincerely

Zoe
 

A:Access: combo box to populate another combo box to populate other fields

Read other 12 answers
RELEVANCY SCORE 46.8

I have recently been named Admin (by default) for a network of about 20 ppl...we have an NT server w/varied operating systems on our workstations, mostly 2k w/some 98 and one 95. my problem is I recently re-installed 98 on one of our workstations (trust me, i lobbied for 2k) the machine can log onto the network but I can't see the machine from the server side...not to mention we have a shared network (again, in the process of lobbying that too) and nobody can see this machine as part of the network. i've tried the basics, renaming the ws, adding it to the nt domain, rebooting, blah, blah, blah.... now it's getting to the point where I feel I may have to re-install 98 but I thought i'd give this forum a shot first...thanks in advance
 

A:win 98 workstation can't be seen on network but has access to files?

Can you ping it?
 

Read other 3 answers
RELEVANCY SCORE 46.8

I'm on a Windows 7 Pro box, and it has been linked to the Domain. I am logged in as Local Administrator account, and when I type the domain name into Windows Explorer (\\Servername), it only comes back "Windows cannot find \\Servername, check
the spelling and try again."
I can Remote Desktop Connection into the server, but when I type "net use Y: \\Servername", or "net use * \\Servername" it only returns "System error 53. Path not found."

When I type "net use \\Servername" however, it connects, and subsequently typing "net view \\Servername" results in a list of shares. But I still cannot get it to work in Explorer.

To add to that, somehow, the Network icon in Explorer (and the Start Menu) is missing. I've checked the registry entries:
HKEY_CLASSES_ROOT\CLSID\{F02C1A0D-BE21-4350-88B0-7367FC96EF3C}\ShellFolder
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Classes\CLSID\{F02C1A0D-BE21-4350-88B0-7367FC96EF3C}\ShellFolder
and they are both set to b0040064.

tried running "sfc /scannow" and it comes back clean. Restarted twice with no luck.

Anything I missed? It works fine on every other PC here (about 90), so it must be something specific to the computer that I'm missing.

Read other answers
RELEVANCY SCORE 46.8

Hello,
I am unable to access craigslist from my workstation. We have four computers networked peer to peering including one running on Linux. The other workstations have no problem accessing their site.

For some reason this one won't. It happened from one day to the next. I have AVG and spybot and ran them both. Aside from tracking cookies, they found nothing. I can ping their site at both the domain name and their ip address and I get the reply "expired in transit".

I checked my firewall (windows) to see if there was some place where there is a blacklist of some type but didn't find anything like that. It happens regardless of which browser I use, Firefox, IE and Kmeleon. I know that it has to be a problem with my workstation. I also flushed the cache in my browser and used the command line to flush the dns cache to no avail. Keep in mind this is happening from only one workstation out of four.

Any ideas what is going on? I use craigslist.com regularly to obtain work and sell items or seek items I need. It is part of my bread and butter.

Any help is appreciated.

Tony

A:Unable to access craigslist.com from one workstation

Browse to C:\Windows\system32\drivers\etc open the Hosts file with Notepad. Delete any lines after
127.0.0.1 localhost
save the file and try it again.

Read other 19 answers
RELEVANCY SCORE 46.8

Hi everybody. I have Small Business network with one file server and 25 workstations in workgroup. Lately I've been experiencing some difficulties. Latest: one of the user cannot sign in into network share on the file server from one computer but can do it from another. I setup same profile with credentials and one is Ok but not another. All workstations have Windows 7 64 bit and our file server is Windows Server 2008 R2. I tried few things suggested on this site but it didn't work.
Thank you

A:Cannot access File Server from one workstation but can from another wi

All I can think of is licensing, upon a search I came across this:
operating systems - File sharing user limits - Super User

See if it is your case.

Read other 3 answers
RELEVANCY SCORE 46.8

Hi!I need access panel replacement key workstation Z800. Where can i get it? KRCHRIS

A:access panel replacement key workstation

Hi @ckct-online?,  Key alone is not available, Whole access panel need to be change. And the replacement might be on chargeable basis. For replacement of the same, you may contact hp Technical Support for further proceedings.  HP Worldwide Contact:http://www8.hp.com/us/en/contact-hp/ww-contact-us.html  I hope that answers your question.  I am an HP employee, the opinions expressed here are my personal opinions, not of HP. Make it easier for other people to find solutions, by marking my answer ?Accept as Solution? if it solves your problem. ***Click on "Thumbs up" button to the left side of my post to acknowledge the post *** 

Read other 1 answers
RELEVANCY SCORE 46.8

I wanted to use a combo box in Access97 so the drop down list shows the previous data typed in and also allows new data to be typed in and will be part of the combo box list on the next record.
The field is currently just a text box.

Thanks
Grenge
 

A:Combo box help in Access 97

I can think of two ways to do this.

1) Create a special table with one field that will hold all data entered in the combo box. Use this table as the row source of the combo box. Enter data into the table as follows:

In the After_Update event of the combo box put an append query along these lines.

<BLOCKQUOTE><font size="1" face="Verdana, Arial">code:</font><HR><pre>CurrentDb.execute "Insert Into tblMyTable Values(" & chr$(34) & _
me!cmbNameOfComboBox & chr$(34) & ")"[/code]

Since the data is stored in a table it will remain even after the form is closed. If you don't want that you might rather use method 2.

2) In design view set the Row Source Type property to Value List and leave the Row Source blank. I am not sure but I believe that when the row is blank it returns an empty string (as opposed to a Null). If I'm wrong this code will need some miner adjustment.

In the After_Update event put the following code:

<BLOCKQUOTE><font size="1" face="Verdana, Arial">code:</font><HR><pre>me!cmbNameOfComboBox.Rowsource= iif(me!cmbNameOfComboBox="","",";") & _
me!cmbNameOfComboBox[/code]

When the form is closed all properties are reset to what they were at design time so closing the form will clear the list.

In both cases the Limit To List property MUST be False.

I did not try this code yet myself so... Read more

Read other 3 answers
RELEVANCY SCORE 46.4

Hi Everyone,

I am currently using a Windows 7 (x64) computer on a Domain. The Domain Controller is a Windows 2008 R2 computer. I have Administrator access to the Windows Server as a result I can alter any settings that I see fit.

Recently a number of staff members have been logging onto my Windows 7 computer without my consent.

I would like to limit access to my computer so that only my Domain Account can logon. Ideally this will mean only allowing my personal Domain Account access, and by extension prevent the Domain Administrator from logging on as well. I am not the only staff member with Domain Administrator privileges, and I ultimately want to make my computer inaccessible to all staff with the exception of myself (naturally).

Any suggestions here will be greatly appreciated.

Kind Regards,

Davo

A:Limiting access to a Windows 7 computer (workstation) that is on a Dom

  
Quote: Originally Posted by Mr Davo


Hi Everyone,

I am currently using a Windows 7 (x64) computer on a Domain. The Domain Controller is a Windows 2008 R2 computer. I have Administrator access to the Windows Server as a result I can alter any settings that I see fit.

Recently a number of staff members have been logging onto my Windows 7 computer without my consent.

I would like to limit access to my computer so that only my Domain Account can logon. Ideally this will mean only allowing my personal Domain Account access, and by extension prevent the Domain Administrator from logging on as well. I am not the only staff member with Domain Administrator privileges, and I ultimately want to make my computer inaccessible to all staff with the exception of myself (naturally).

Any suggestions here will be greatly appreciated.

Kind Regards,

Davo


How are they able to log onto your account unless you gave them the password for your account?

Read other 5 answers
RELEVANCY SCORE 46.4

Hello Team, 
My colleague has created a VMWare image for me. When I logon I am able to see C & D drives. I am able to access C drive. But all the program files in D drive and any program I click it says doesn't exists. When I checked D drive i found i am unable to
access D drive and I am getting access denied error. 
I have tried enabling user in Drive security tab properties but it is not allowing me to make any changes.
Can you please help. 

Regards,
Venkat

Read other answers
RELEVANCY SCORE 46.4

I have been tasked with the job allowing a specific set of users to log on certain workstations. For example, only accounting users will have access to the workstations in the accounting department. They will not be able to use workstations in
other departments and other department users  will not be able to use the accounting department workstations. I am manually testing a few workstations.

What I have done so far:
Administrators Group
In the administrators group: I have Domain Admins and the Administrator account (I have to remove local admin rights for our users)
Users Group
In the users group: I currently have Authenticated users and interactive users. 

I want to remove authenticated users and add the accounting group, system, and domain admins.
Is this ok to do? If I should not remove authenticated users, I need to explain why and document.  Thank you.

Read other answers
RELEVANCY SCORE 46.4

Hello again,

Another problem has occurred. We thought we had many of our computers blocked from the internet. We have found out differently . Is there a way to block internet access and or limit the access to a list of acceptable site needed for work, ie. Vendor sites. Additionally, do you have a good internet usage monitoring software you recommend.

Thanks everyone

A:Blocking a employee workstation from internet access

I have located this program which looks 'interesting' ,http://www.toplang.com/internetlock.htmbut please bear in mind I have never ever used it; maybe someone who has user experiece with a program can advise further

Read other 4 answers
RELEVANCY SCORE 46.4

Hi everybody. I have Small Business  network with one file server and 25 workstations in workgroup. Lately I've been experiencing some difficulties. Latest: one of the user cannot sign in into network share on the file server from one computer but can
do it from another. I setup same profile with credentials and one is Ok but not another. All workstations have Windows 7 64 bit and our file server is Windows Server 2008 R2. I tried few things suggested on this site but it didn't work.
Thank you

Sam Goykhman

Read other answers
RELEVANCY SCORE 46.4

I'm running Windows 7 and VMWare Workstation 7, and I cannot access the internet from any virtual machines using bridged connections. I used to be able to, so I'm not quite sure what happened. I did not modify anything within VMWare....

bridged connections are set as they were by default - to use vmnet0. They are capable of pulling an IP and DHCP info from the router, but beyond that they cannot access the internet or do anything else.

On the win7 host machine, under network adapters, I do not see vmnet0 listed - I'm not sure if it is supposed to be or not. It only shows vmnet1 (host-only) and vmnet8 (NAT).

I would rather use bridged connections if possible, but just cannot seem to get it to work.

Yesterday, I couldn't even get NAT to work. It could ping servers, but I couldn't actually use the internet - I guess ICMP was working but not TCP for some reason, although I hadn't modified anything. I updated from VMWare 6.5 to 7.0 and now NAT works, but bridged connections still fail.

Does anyone have any ideas what the problem might be? I've searched the web for solutions but haven't found any that worked (disable vmware adapters, modify registry so that they don't show up under public unidentified networks, etc).

Could it be related to the fact that vmnet0 doesn't show up anywhere on the host machine? I'm not sure if it is supposed to or not - vmnet1 and vmnet8 both show up under network adapters and using ipconfig/all. However, vmnet0 does not show up between ei... Read more

A:Windows 7 + VMWare Workstation 7 - no internet access

I am having this exact same problem on my system right now. Did you ever find a fix for it or does anyone else have one?

Read other 1 answers
RELEVANCY SCORE 46.4

Hi all, I'm tryin to have 3 combo boxes for users to enter dates. The Month and Year combo boxes are very easy but I'm having trouble with the day combo. I want this to be an intelligent box in that it will only display days based on the month, ie. 28 when month is set to February and 31 if on January.

I'm just wondering if there is an easy way I should look at to accomplish this, I tired some VBA that was unsuccessful.

I essentially addItem all days 1-28 and then had if checks to see if i needed 29, 30 or 31 days. Errors occurred when I would go from a month with 31 days to 30 and then to 29/28 because it would attempt to remove 31 from the list but it wouldn't exist since when switching to the 30 day month got ride of 31. Unless there's a way to bypass this I need a pointer.
 

A:Access 2010 Day Combo Box

Wouldn't it be easier to use the Built in ActiveX Calendar?
 

Read other 3 answers
RELEVANCY SCORE 46.4

I am trying to set up a form thart uses a combo box to select a name from a table and will then put the correct address details in the boxes underneath automatically......help!
 

A:Access Combo boxes

Create your form.

In the header of the form, drag a combobox from the control toolbox (you may need to "turn the control toolbox on").

The wizard should take over from that point and you want the one that allows you to "look up a value to display in the form" or something like that is what it says.

If the wizard doesn't kick in, I'd close out of all of it, get my disk out and reinstall Office. A typical install of Office does not include the wizards---ya believe it??
 

Read other 2 answers
RELEVANCY SCORE 46.4

Hi, i have a database of clients. When im in the invoice form i want to be able to select a client from the combo box and then automatically add there address to a box on a box to the right hand side of the form. Is this even possible? I have around 50 clients so it's pretty time consuming adding there address every time we send them an invoice.

Thanks in advance.
 

A:Solved: Access Combo

Read other 16 answers
RELEVANCY SCORE 46.4

Hi! I am placing a combo box in a form within access, the problem is that when I select the item from the combo box that item is them added to the list in the table that contains the information for the combo box.

i.e. I want the combo box to use the selected item but not add that value to the table, which is creating duplicate data.
 

A:combo boxes in access

Read other 8 answers
RELEVANCY SCORE 46.4

I have a combo box on a form that is bound to the "Name" field in my database. The user clicks the combo box and is able to choose from all the names in the list. When the form is loaded, the first name in the list is automatically shown. Is there a way to have the combo box blank (when the form loads) until the user chooses a record from the list?
 

A:(Solved) Access - Combo Box

Read other 6 answers
RELEVANCY SCORE 46.4

My computer tech had me install and run combo fix a few months ago, or more, as I evidentially had been infected with the RootKit.Zero Access. It had disabled my mouse and key board. I was able to plug in other devices through usb ports and I ran the combo fix, and then malware bytes. I was able to regain access to my desktop, but the original mouse and keyboard with the older plugs will no longer work.

Recently I ran combo fix again and after running for a while it said my machine was infected with the RootKit.Zero Access!! It said it had been inserted into my tcp/ip stack, and that it could be hard to remove. It ran for a while longer than said it was going to re-start my machine, which it did. When it restarted I also had to log in again with my user name. I had disable my security essentials anti-virus prior to running combo fix, but after the reboot it came back on with the restart.

I also ran Malware bytes and it found noting.

Today I clicked on the combo fix icon and it said combo fix had expired, asking it i wanted to run it in limited functionality or something to that effect. I clicked yes and it deleted the icon from my desktop and did nothing else.

Please advise.

A:Combo Fix and Zero Access rootkit

Hello having run ComboFix we need to see that and a DDS log.Please go here....Preparation Guide ,do steps 6 - 9.Create a DDS log and post it in the new topic explained in step 9 which is here Virus, Trojan, Spyware, and Malware Removal Logs and not in this topic,thanks.Skip the GMER step and instead post the ComboFix log you posted earlier.Let me know if that went well.

Read other 1 answers
RELEVANCY SCORE 46.4

Morning Guys,

I am quite new to access and I am trying to set up a database which users can enter data for any lost time system issues.

I have created a database which holds all the relevant data such as user, incident tracking number, time lost etc. For the end user to input this information I have created a form which is easy enough to use and compiles this data. Now this all works fine, but the users have requested that when they select their name from the current combo box on the form, they would like the incident number to be able to be chosen from a drop down menu.

So when they select their name, they would like a dropdown box to select from the incident numbers raised. This information is held in another table. How do I link this to my form using an expression or query?

Thanks
 

A:Combo Box Using an expression in Access

GeordieMCG, welcome to the Forum.
You only need to set the combo box's Row Source to the Incident Number in the table, or if you want to "order" the numbers use a query for the Row Source.
 

Read other 1 answers
RELEVANCY SCORE 46.4

I have a combo textbox in a form. The combo box has only 1 value avalailable to pick. How can i make that the default value that is set automatically when the form is opened.

if the combo box's value is "blah"
i want the blah to be filled in the combobox when i open the form

any ideas?
thank you
 

A:access combo box question

zr3cool, why would you want to use a combo box, which is for "selecting" a choice if you don't want the user to select anything. Why not just put the value straight in the field?
What you want is the Default Value.
 

Read other 3 answers
RELEVANCY SCORE 46.4

Hello,

I am trying to write code to do 2 things:
1). automatically delete a value from a combo box and
2). if there are related records, to show a message saying which records have related fields.

I got the first part almost done....

i have a table called tblJobDescription with 2 fields:
autonumber primary key field JobDescriptionID and text field JobDescription.

In my main table called tblClient I have the foreign key called JobDescriptionIDLink.

in my form, i have the combobox called JobDescriptionIDLink with the recordsource:

SELECT DISTINCT [tblJobDescription].[JobDescriptionID], [tblJobDescription].[JobDescription] FROM tblJobDescription ORDER BY [tblJobDescription].[JobDescription];

i tried the following code:

Private Sub JobDescriptionIDLink_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 46 Then Call DeleteComboValue(Me.JobDescriptionIDLink, "tblJobDescription", "JobDescription")
End Sub

Public Function DeleteComboValue(txtCurrentValue, txtTblName, txtFieldName)
'deletes a value from a combo box automatically

Dim rs As DAO.Recordset
Dim strSQL As String
' Ask the user whether to delete a value from the list.
If MsgBox("Do you want to delete " & "'" & txtCurrentValue.Column(1) & "'", vbQuestion + vbYesNo, "Delete value?") = vbNo Then
DeleteComboValue = acDataErrContinue
Else
strSQL = "Select * from " & txtTblName & " where " &a... Read more

A:Access-delete combo box value

Bear in mind I'm new to the access thing, but I think there are two problems
Code:
If MsgBox("Do you want to delete " & "'" & txtCurrentValue.Column(1) & "'", vbQuestion + vbYesNo, "Delete value?") = vbNo Then
DeleteComboValue = acDataErrContinue
Should be
Code:
If MsgBox("Do you want to delete " & txtCurrentValue.Column(1), vbQuestion + vbYesNo, "Delete value?") = vbNo Then
DeleteComboValue = acDataErrContinue
. As for the SQL Its hard to say without knowing what datatypes the variables are. In sql the strings need quotes, integers don't. So assuming they are all strings then this may work

strSQL = "Select * from " & "'" & txtTblName & "'" & " where " & "'" & txtFieldName & "'" & " = " & "'" & txtCurrentValue & "'"

Variables that are integers can do away with the

& "'"

(On the code above three double quotes in a row should be double quote - single quote - double quote, for some reason the forum page seems to change it to double quotes)

EDIT

Also, possibly

txtCurrentValue.Column(1)

should be

(txtCurrentValue)Column(1)
 

Read other 3 answers
RELEVANCY SCORE 46.4

Hi,

I have created a simple database to hold simple music information.

On the mainform there is a find combo where i search for artists, when data is selected it refreshes the subform with the artists tracks which works perfect.

Last night i added code to the NotInList Event of the combo so i can add data to the artists table if it is not there. I have found after adding data to the table through the not in list event the subform is not refreshing.

Can anyone help me with the code to refresh the subform when data is added using the NotInList Event?

Thanks in advance.
 

A:Help with combo box Access 2003

You need to add the following code to end of the Not in list code
me.subformname.refresh
where subformname is the actual name of your subform, the vba Editor should provide this when you type in the me.
 

Read other 3 answers
RELEVANCY SCORE 46.4

Ok, I'm stumped.

I've built a combo box in a field that is part of a subform. It uses a query of another master file to collect acceptable elements (ie jobs related to a specfic type of mold). The query selects data from the master table based on the Mold ID displayed on the form and works fine.

My problem is this.........

When I click the pulldown box, the query returns the correct number of possible records, but the bound column is BLANK! If I click one of the blank rows, the field is correctly populated with whatever is in that row, but I have no idea what the value is before hand.

As I said before, the query works (I can get out of the form, access the query and everything is correct). I have checked and rechecked all of the properties and all of the linkages. I have checked all of the possible formating options. I have made sure that the display feature on the query itself is checked for the bound column, yet it always returns blank information. What is so maddening, I have an identical lookup process in the field that proceeds this one, and it works fine! The only difference is that that field is a numeric lookup while my problem child is a text lookup.

What causes an alpha lookup to "display" blanks (again, the query indicates that the data is there)?
 

A:Combo box in Access 2003

Read other 16 answers
RELEVANCY SCORE 46.4

I have a combo box setup to populate a listbox found on a subform. However, there are some entries in the combo box that are empty, so they do not populate the listbox.

Is there a way to hide the entries in the combo box that will not populate the listbox?
 

A:Access Combo Box and List Box

Read other 16 answers
RELEVANCY SCORE 46.4

Hi guys first post here, and I've been racking my brain on how to resolve this but am hitting a wall.

I'm basically having trouble using RDP from my study machine accessing the server downstairs. It just doesn't seem to want to accept the user credentials, however these same credentials work fine on other local machines to access the server.

I've attached an image of my network rather than trying to write it to explain.
So basically my Server is running Windows 8.1 Pro with remote services turned on and firewall settings configured

Study PC is also running Win 8.1 pro as above

Study is setup to to accept RDP sessions on port xxxx

Server has had it's registry updated to allow RDP sessions over a different port

All configured in the router on the port forwarding rules

The Study PC can be accessed via internal network remote sessions on Mac and iOS devices. It can also be accessed from the external network from my workstation at work

The Server PC can also be accessed via internal network remote sessions on Mac and iOS devices with no issues, and also from my workstation at work.

However, from my Study PC I simply am unable to access the Server PC via RDP at all. It just won't accept any user account credentials I enter into the log on info.

I've checked port settings. Windows Firewall settings for incoming and outgoing traffic rules, on both machines.

I have tried the following in the computer box on the RDP windows log on client

servers local IP in format [ 10.0.... Read more

A:MS RDP to internal workstation not working

Firewall rules would be why. Easier to just use Teamviewer, since that is what everyone is going to, instead of RDP, which to this day has a lot of issues, that Microsoft will not fix.

Read other 1 answers
RELEVANCY SCORE 46

Hi Everyone,

I am currently using a Windows 7 (x64) computer on a Domain. The Domain Controller is a Windows 2008 R2 computer. I have Administrator access to the Windows Server as a result I can alter any settings that I see fit.

Recently a number of staff members have been logging onto my Windows 7 computer without my consent.

I would like to limit access to my computer so that only my Domain Account can logon. Ideally this will mean only allowing my personal Domain Account access, and by extension prevent the Domain Administrator from logging on as well. I am not the only staff member with Domain Administrator privileges, and I ultimately want to make my computer inaccessible to all staff with the exception of myself (naturally).

Any suggestions here will be greatly appreciated.

Kind Regards,

Davo

Read other answers
RELEVANCY SCORE 46

Hi Everyone,

I am currently using a Windows 7 (x64) computer on a Domain. The Domain Controller is a Windows 2008 R2 computer. I have Administrator access to the Windows Server as a result I can alter any settings that I see fit.

Recently a number of staff members have been logging onto my Windows 7 computer without my consent.

I would like to limit access to my computer so that only my Domain Account can logon. Ideally this will mean only allowing my personal Domain Account access, and by extension prevent the Domain Administrator from logging on as well. I am not the only staff member with Domain Administrator privileges, and I ultimately want to make my computer inaccessible to all staff with the exception of myself (naturally).

Any suggestions here will be greatly appreciated.

Kind Regards,

Davo
 

A:Limiting access to a Windows 7 computer (workstation) that is on a Domain

Unfortunately we can not advise on this issue as it could be in breach of the company's policies and we have no way of proving what rights you have to block access to your account. We would be totally in the wrong if we were to give any advice that could circumvent company policy.

If you are permitted to make such changes then your Domain Administrator is the person you need to ask.
 

Read other 3 answers
RELEVANCY SCORE 46

Hi,

Ive created a failry simple Access database to record incoming calls and referrals. Everything is working fine appart from one section in one of the forms. What I want to do is let the user select a "Reason" and then select a "Sub Reason". The contents of the "Sub Reason" combo box should change dependent on what is selected in the "Reason" combo box.

I have created tables for both Reason and Sub Reason which have a field linked through a one to many relationship (this field is named Reason).

Could someone please give me a step to step tutorial of how to set up this system of one combo box based on another. This problem is really annoying me at the moment and I have tried following the Microsoft websites tutorial but its hard to follow.
Please people help me!
 

A:Access 2003: Basing one combo box on another

Read other 16 answers
RELEVANCY SCORE 46

I need to create a combo box that functions this way:

while browsing the options on the drop down, each option is linked to an image that should be displayed during browsing (not after selection) Selecting will be a later option, but images must display during browsing, and refresh once the mouse moves either to the previous or next option.

I think this leads to the move mouse event on the combo box, but I need some ideas.

Anyone?
 

A:access 2003 combo box question

Hey there, welcome to the site.

First, you can't do this with a MouseMove. You'd have to DropDown on Enter, then on Change do your image change. However, I don't know if the control's value will be the suggested value or the literal input. (Just tested, the Value is Null; you'd have to use the Text property.)

However, the Change event fires for every keystroke. So, it will work if you key up and down through the list, or type the first few characters of the item. But it will also fire if you backspace, delete, etc. I think it'd be more reasonable to use a single-select listbox, because for that you could use the ItemsSelected and the Change event--it's still not great but it'd work more cleanly than a combo box.

HTH

chris.
 

Read other 2 answers
RELEVANCY SCORE 46

Repeatedly re installed operating system on hard drive. Monitor goes to no siganl after some use. internet veryyyy slow. Followed malware removal on major geeks. Combofix says I have rootkit.zero access infection. Ran combofix a couple of times - still have infection. I have attached the logs you requested after following your instructions. Help!

A:Infected with rootkit.zero access in TCP/IP - Combo fix says so

Hello duhhh7 and welcome to Bleeping Computer! We apologize for the delay in responding to your request for help. Here at Bleeping Computer we get overwhelmed at times, and we are trying our best to keep up. Please note that your topic was not intentionally overlooked. Our mission is to help everyone in need, but sometimes it takes just a little longer to get to every request for help. No one is ignored here. Please print or save this topic: it will make it easier for you to follow the instructions and complete all of the necessary steps. -------------ComboFix is an extremely powerful tool which should only be used when instructed to do so by someone who has been properly trained. It is intended by its creator to be used under the guidance and supervision of a Malware Removal Expert, not for private use.Using this tool incorrectly could lead to disastrous problems with your operating system such as preventing it from ever starting again.-------------Please do the following:Please download aswMBR.exe from here and save it to your Desktop. Double click aswMBR.exe to start the tool. (Vista - Win 7 Rt click to run as Administrator)Click ScanUpon completion of the scan, click Save log and save it to your Desktop, and post that log in your next reply. Do NOT attempt any Fix at this time! This will also create a file on your Desktop named MBR.dat. Right click that file and select Send To->Compressed (zipped) folder. Attach that zipped folder in your next reply as we... Read more

Read other 4 answers
RELEVANCY SCORE 46

Hi,

Ive created a failry simple Access database. Everything is working fine apart from one section in one of the forms (frmWorkPackageBreakdown). What I want to do is let the user select a "System/Area" and then select a "Sub System/Area". The contents of the "Sub System" combo box should change dependent on what is selected in the "System" combo box.

I have created tables for both System and Sub System which have a field linked through a one to many relationship (this field is named System).

Could someone please have a look at the attached DB and Form (WorkPackageBreakdown) and provide me a step to step tutorial of how to set up this system of one combo box based on another. This problem is really annoying me at the moment and I have tried following the Microsoft websites tutorial but its hard to follow.
 

A:Access 2003: Basing one combo box on another

Read other 6 answers
RELEVANCY SCORE 46

hi

I am having two fields in my table, one is Item No and second one is Description of Service. when i select the Item No i want the Description of service to appear automatically how do i do it.
Can anybody give me a step by step process to do it.
your help would be appreciated.

Thanks
 

A:Solved: MS Access Basing one combo box on another

Read other 7 answers
RELEVANCY SCORE 46

I have a form and I want to have a combo box that will Give today’s Date 5/1/2005 as a selection.
That would be today’s date.
If I select this date it will place this Date in another field That I have formatted as a short Date.
This date must remain in this box even if I close the program.
I tried to use a query but when I go to the combo box it shows a blank cell.
It does enter today’s date in the cell I want it to but you cannot view it as with other combo boxes.
 

A:Access-Getting Date in a form Via Combo Box

i'm not sure how to do the date with a combobox like you mentioned above, but here is another way to do this:

Private Sub txtDateCreated_Click()

'if there is not a date in this field, then when the user clicks in the box, the current date is displayed.

If IsNull(Forms![frm1]![txtDateCreated]) Then
Forms![frm1]![txtDateCreated] = Date
End If

Put a label near the text box saying something like 'click to enter today's date'.

i like this method because instead of needing both a combobox and a text box, you only need a text box.

i am assuming that your combobox would only contain the current date. in that case, you don't need it. is that right or were you going to display other values in the combobox along with the current date?
 

Read other 2 answers
RELEVANCY SCORE 46

Hi Guys, me again...

Still working on my database and combo boxes.

At the moment I have a combo box [SelectReportList] that lists all the available reports to run.
I also have 2 combo boxes [SelectSupplier1] and [SelectSupplier2]that allow the user to select a supplier based on what report is selected in the first combo box. These 2 combo boxes are visible or not depending upon which of the 2 reports in box one are selected. To make the form tidy I have layered the two combo boxes on top of each other. As far as the end user is concerned, if they select a report where they have to choose a supplier, they see the combo box to select the supplier. I know its a bit 'clunky', but for only 2 reports it works.

However, I was hoping that I could replace these 2 combo boxes [SelectSupplier1] and [SelectSupplier2]with just one [SelectSupplier3]that displays the suppliers and runs the relevant report.

i.e.
If the user selects Supplier Report 1, the suppliers are displayed in the new combo box. When the user selects the supplier, Supplier Report 1 is generated.
If the user selects Supplier Report 2, the suppliers are displayed, but when the supplier is selected Supplier Report 2 is generated.

I've been experimenting with Select Case and the RunSQL commands in the code builder but can't find a way to get it to work. I need the code to tell 'it' that whatever is selected in [SelectSupplier3] runs the SQL in the RowSource property for the two reports in ... Read more

A:Access 2010 and Combo boxes again

Karen, a question first, are you using Access Macros or VBA Code?
 

Read other 3 answers