Recent content by TJones76

Ok, the spaces in my table name caused the errors, so with all that fixed, the query runs but it asks for a parameter value of the test date, is this the best way? Or is there a way to do the updating automatically without having to enter in the test date and test number for each (there are...

Hi TomHW, I'm getting a syntax error on UPDATE with this code. I put it in exactly as you have but replaced "MyTable" with the actual table name. -T -TJones

Perfect, that is exactly what I'm wanting to do. I'll give this a try. Thank you Both! -Tiffany -TJones

Remou, Forgive me, I'm sort of a visual learner, can you show me what you mean or explain it more thoroughly? How exactly do I populate the null fields in my table with the two queries? Thanks, -T -TJones

Hi All.. I have a huge table that came from several tables with some of the same information. Now I need to clean it all up so it's nice and pretty and remove all duplicates. To do that I first have to populate the "Serial Number" column completely... some of the tables were missing the # but...

Hi All, Ok, this may sound really ignorant, but I'm wondering if it is possible to set up my Vonage phone using my cable modem and Linksys RT31P2 with no computer. You see, my computer is in the shop, my cable modem is still active and i need my phone. What to do??? Thanks for any help you...

Thank you PHV! That did it. [2thumbsup] -TJones

Hi, I'm having the same problem with type conversion errors. Does anyone know the fix for this? I've got a column of numbers, some are alpha-numeric. I've tried converting the column to text, number, generic etc and nothing works when I try to import the spreadsheet. Any ideas out there...

Yes, it's a drop down list (table field is based on another table of names) on my Form that when I select a name it populates the field, i checked my main Table that the form is tied to to make sure that it's showing the name that I've selected.. and it does. But for some reason the Report...

What was the solution to thise one? I have a similar situation that I need to do with 14 separate worksheets that are on a network drive.. i need to link these into access ..into 1 table for analysis. Also, one of the problems i've encountered is data type mismatch issues with linked...

Hi there... I have a problem with my report, which is based on a table: The combo box field in the report shows all of the combo box entries.. instead of just showing the selected value. My table shows only the selected value for that field, why isn't my report showing the same?? Thanks for...

Thanks Lupins46... Yeah this is my first attempt at securing a database.. what you said makes sense as to why it's not working... man it would be so much easier if someone could just show me how to do this step by step and explain the "whys". I'll read up on the info in the link you provided...

Hi! I'm a new one for setting up security features in a database. I've set up group level security on a database and it works fine on my computer, but now I've got two problems: 1.) When opening the database from another person's computer, it opens in Admin role...does not ask for any logon...

Thank you! -Tjones76

Disregard my last msg, for some reason there were fields missing out of my query... thus the parameter values. But I'm still stuck with my problem of updating default values through the extra table.. the code is not inserting the values based on the extra table. Thanks again.. -Tjones76