Recent content by comgentech

This problem is fixed Thank you so much for all your help you guys are great.

Not sure what your asking but, I hope this helps. The first query is on a button that adds a new customer from a form to our customer db. The second query is on a button that edits an existing customer on a form and then updates the information in the customer db. so the update query is suposed...

i really Thank you guys for all the help, I have most of my programming experiance from access. I am still very green in vb programming. One thing I have learned is not to tie tables to forms and that spaces are a pain so next time I will not use spaces. However this database is old and I am...

I Have found the problem to this SQL statement, I removed the & signs and access 2002 seems to be happy with that it's working fine now but I have an update query that is giving me the similar error only is error 3464 data type mismatch maybe you can see something here that Might help.. code>...

I have gone over and over this and cannot find the issue with this code can anybody help me? Dim StrSql As String StrSql = "INSERT INTO [Customer Table] ([Customer ID], [First Name], [Last Name], [Company Name], [Main Phone], [Alt Phone], [Address]) SELECT " & [Customer ID] & " As [Customer...

I am a small ISP with dialup internet access as well as S-DSL and wireless my problem is I have 2 customers that can browse the internet fine execpt they cannot see our mail server, my website, my ftp site or anything on my kancom domain. both customers are on the wireless with a small network...