Posts by qajaq49

Bob, the relevant section of the SQL is this:

...WHERE (((t_Notes.Topic)=[Forms]![f_EditNotes]![cboTopics]) AND...

What do you mean by your reference to concatenating?

No, the source for the form is a separate table created just for the purposes of populating the Combo Boxes in the form and in the table being queried. The form works as expected when I open it simply as a form. It's just when I try to use it as a criterion within the query that I get the disappointing behavior. But you've given me another avenue to look into. I'll check the relationships links when I get back to the office, and see if there's something missing there.

Thanks, Chris -- I appreciate the "cut to the chase" help. I'll give this a try when I'm back at the office (next week).

I'm also curious, for the sake of learning this aspect of Access generally, why the object is not being recognized.

In MS Access2007, I want to query (q_Notes) a table (t_Notes) in which one of the fields (t_Notes.Topic) is populated from a Combo Box based on a field in another table (t_Topics.Topic). I will have a table of several hundred records. I want to use the q_Notes query as the basis for a report showing all the notes posted for any given topic.

I've created a form (f_TopicSelect) that includes an unbound Combo Box (cboTopics) based on that same table and field (t_Topics.Topic) as in the t_Notes table that will be queried. When viewed as a stand-alone form, the Combo Box displays the list of values as expected.

I've specified the Combo Box as the criterion for the Topic field in my q_Notes query as follows:

[Forms]![f_TopicSelect]![cboTopics]

(I know the spellings are correct because I used the "Build..." function to insert these values.)

When I run the query I get a Text Box that prompts me for the value of "Forms!f_TopicSelect!cboTopics" rather than the expected Combo Box listing of allowed values. The Property Sheet for this control assures me that it is a Combo Box, that the Row/Source type is "Table/Query" and the Row Source is "t_Topics".

If I edit the properties of the Combo Box in any way and save the changes (and even if I then change them back to what they were in the start), no prompt of any kind appears for the Topic -- neither a Text Box nor a Combo Box.

Any ideas what might be going wrong here?

New card received from Dell; installed. Driver un-installed. Wireless disabled in BIOS, computer re-booted, then wireless re-enabled and computer re-booted again. Driver re-installed. Still no wireless signal, neither in WinXP nor in Linux. At Linus CLI, neither ifconig nor ip link show will list the wlan0.

Good to know that. I did get the driver from Dell, in fact. I'm increasingly inclined to believe it's a hardware issue. I've ordered a new wireless card (again, from Dell) and I'll post an update here after I get it installed.

I do not follow the syntax of your question exactly, but if you're asking if the wireless card is enabled in the BIOS set-up, the answer is yes -- that's what I did in accordance with avarionist's final suggestion. It was enabled when I first checked; I disabled it, rebooted normally; re-enabled it; and rebooted normally once again. Still no wireless reception.

Another bust, I'm afraid. When I tried ifconig wlan0 up, I got the error message: "SIOCSIFFLAGS: No such file or directory"

I re-booted and got into the BIOS set-up, found an embedded wireless option and ran through the disable-boot-enable-boot sequence suggested, but wicd still shows "No wireless networks found" and the ifconfig command returns the same error message as above.

Checked that. No wireless device is listed. I have deleted and re-installed the Dell wireless device driver, but still find no wireless device listed.

Okay, thanks. I gave that a try this morning and was able to get the Ethernet connection working.

I still do not have a wireless connection. Other resources on-line have suggested I use the Network Connections icon (in the WinXP Control Panel) and open the Wireless Network Connection icon -- but there is no such icon in the Network Connections folder on my machine. When I open the network connection software in Linux, it reports that no wireless networks are found, even though I have my wireless router on and set to broadcast the SSID, and I know there are numerous other wireless networks active in the neighborhood.

I'm happy to have the Ethernet connection back. That makes it possible, at least, to connect to my network, but it would be nice to be able to do so without the cable, so I could be more mobile.

Any further suggestions?

I have a Dell Latitude 610 laptop -- had it for about 2.5 years. It's set up to dual-boot Kubuntu 9.04 and Windows XP (SP2). For a long time, I was able to connect to my home network or other networks either wirelessly or by Ethernet. The computer has both capabilities built-in.

Several months ago, however, I found myself unable to make a network connection. First, it was just the wireless gone bad. I couldn't connect to any network with either OS. I am fairly certain it's the computer, not the router, as a neighbor was able to see and connect to my home network with her wireless machine. At that time, though, I was still able to plug in the Ethernet cable and get into the network.

A few weeks later, though, I found myself unable even to connect via the Ethernet cable. I know it's not a cable or router problem because I can use the same cable and the same jack on the router to connect a different computer to my network; the computer is the only variable. Again, the failure is OS-independent -- can't get on-line with either Windows or Linux.

Anyone have any suggestions how I might get this machine back on-line?

I probably wasn't clear enough. I have no trouble changing the timezone or, for that matter, the date and time. The problem is that Windows appears to misinterpret it.

I have my Linux OS set up to read an internet time server, so that it keeps the machine clock as near perfectly-set as even an obsessive like me can expect. But when I reboot to the WinXP OS, Windows tells me that it's four hours later than it actually is. If I reboot directly back to Linux, the time is again shown correctly.

From this I deduce (perhaps incorrectly) that the system clock is not changed, but that Windows, for some reason, assumes that the system clock is reporting UTC and -- since I've told Windows that I'm in the US Eastern timezone -- Windows adds four hours to the system-clock time to make up for the timezone difference between UTC and EDT.

It's not that I have any trouble telling Windows what timezone I'm in. Rather, I want to tell Windows that the system clock is set for my timezone, not for UTC.

No dice, but it was worth a look.

My main desktop computer is set to dual-boot Linux and Windows XP Professional. I have the Linux OS set up to sync time with an internet time service. When I boot the WinXP OS, the time consistently shows four hours late -- as though it's interpreting the system clock to be on UTC (I'm actually in the US EDT zone).

Does Windows have a function, someplace, that can be told whether the system clock is set to UTC or to local time?

Or is there some other possible explanation for this consistent error?

Thanks for the suggestions. I'm going to copy them into a file on my HDD in case of future need. As it is, though, I re-installed my OS (for other reasons) and found that the box is now connecting to the Internet just as though it were a normal machine.

That was it -- thank you, Aia!

I'm trying to write a short bit of C code that will get a filename from the user, via the keyboard, and open the specified file, but I haven't been able to get fopen() to recognize the variable filename when I use fgets() to get it. Here's a snippet of the troublesome code:

#include <stdio.h>
#include <errno.h>

#define LINELEN 128

main() {
...
FILE *finptr;
char filename[LINELEN];
...
fgets(filename, LINELEN, stdin); /* Get the filename from the keyboard) */
if ((finptr = fopen(filename, "r")) == NULL) printf("Error in fopen: Error #%i\n", errno);
...
return 0}

I don't get any errer message when I compile, but when I run the code, I get the error message I defined in the if-statement:

Error in fopen: Error #2

If I use gets() instead of fgets(), the program works as expected. I am then able to read a line of text from the named file and display it on my monitor.

Apparently the return value from gets() differs in some way from the return value of fgets() -- enough to break the code as I've written it.

Any ideas what I'm doing wrong and how to fix it?

Looks like a resource restriction problem on the uplink between Belink and ADSL modem.

NAT table on the Belkin full ? Or maybe you "parental controlled" the box'es mac address ?

Hey, thanks for the input! As to the PC, that's a negative. Parental Control is OFF and all my computers are on the Belkin's white-list.

I don't know about the NAT table -- That is, I know what NAT stands for, but as far as finding it, reading it, editing it -- I'm totally in the dark. I've been poking around the Belkin's configuration menus for about a half-hour since reading your suggestion, and I've been looking for guidance via Google, but I haven't found anything that looks useful. Any suggestions as to where I might learn more about working with the Belkin's NAT table?

do you get name resolution when pinging google.com?

No. If I ping the domain name, with or without the 'www,' I get "unknown host." If I ping 216.239.32.10 (one of Google's IP addresses), I get "Network is unreachable."

I have a Belkin N router that connects to two desktop machines (via Ethernet cables) and one laptop (usually via wireless, but can be connected by cable as well) on one side, and to a Zoom DSL modem on the other side. I can connect to the Internet with one of the desktop machines and with the laptop (either wireless or wired), but not with the other desktop machine.

The laptop is running Ubuntu 8.10, and the desktop that does make the Internet connection is running open SuSE 11.1 and Windows XP (dual-boot). All three of these connection options are configured with static IPs.

The other machine has been formatted at various times over the past few months with openSuSE 11.1, Centos 5.2, and Fedora 10. I have not been able to connect to the Internet on any OS on this machine. I have configured the machine to accept a DHCP assignment at times, and to use a static IP at times. Neither has been successful. When I run the ifconfig command, I'm told that eth0 on the reluctant machine is UP.

From that machine, though, I can successfully ping both the router and the other computers. I can also use the browser on the reluctant machine to read and change the settings on the router.

The two desktop machines are sharing IO devices through an IOGear USB KVM switch. I have tried connecting with both computers running, and with just the reluctant one running. No joy.

So it appears that the reluctant machine is on the local network, but it, alone among its peers, cannot see the Internet. Any ideas where I might look for the problem?