Glad I could help. May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==>...
Sorry for the simplistic questions again, but how do I move through a table one record at a a time so that can check the contents of fields as as I go. Here's...
Okay, so I partly figured out the answer to my own question, which is to use recordsets. Below is the code I found that showed me what to do but THIS doesn't...
The problem may have something to do with your references. Have you included Microsoft DAO Object Library in your list of references? In VBA window go to...
Dears, Pls help me to design table In my future table I have one field name “product name” Another field name “material name no:1” Now I want to know...
Hey, thanks a lot. That was it. I never would have found this by doing random web searches or checking help files. Thanks again. ... included Microsoft DAO...
You are welcome, Bryan Liveson ... From: bryan.leggo To: ms_access@yahoogroups.com Sent: Tuesday, 04 December, 2007 5:30 AM Subject: [ms_access] Re: How do I...
dears, There is any way to have a tables field name should automaticaly liknked with another table becuse i want to design a table in there field name should...
I personally don't know if it is possible to have a field in one table automatically updated when data in a field in another table is changed. What I know is...
Dear Liveson, Thank you for your tips, but this is not one, which I am searching for; it is because my question may lead you in a different way. I will ask my...
hey new to the group :) I have an issue with a db i created in controling when a form can be printed and not allowing duplicate values in a field. Let me...
It seems like Recordset.RecordCount is buggy in a couple of places in my program. Here's one: I have a form that is opened sometimes with a filter (passed as a...
I'm stuck. ... and I'm not sure what the best approach is. ... Post Implementation. The grid shows the corresponding Dates as color blocks. The dates are 1...
This is the first time I've tried to use the OpenReport from within a VB application and from all that I've seen this should be working, but even though I can...
These properties are from an Access 97 database created by an unknown person a long time ago: OLECLASS Threed Panel Control CLASS Threed.SSPanel ENABLED...
Hi everyone, I have a forms that I need to print a report.. when click on cmdbutton "report", an input form pops up where user will enter parameters: 1 for...
I have a dbase for entering airport information. I would like to create a way to auto fill forms based on the condition of the airfield. This will be used...
hey all, merry christmas all, i am new to ms access and i got a task to make a database system for ICDL students in my institute ... i got the data and every...
How much help are you needing? Have you even started? What all do you want it to do? Can you use one of the database wizards? May God bless you beyond your...
Is there a way, without VBA, to make a query on a text field of a table, with such an option : the field contains the substring "abc", anywhere in the field ?...
Lookup "wildcard" in the help section. The jest of it is... SELECT MYFIELD FROM MYTABLE WHERE MYFIELD LIKE '*ABC*' This will return such as ABC 1ABC LAABCLA ...
I really didn't get an answer from anyone that helped me with the date range question. Could anyone please take a look at it again for me? I have written a...
Dear Bud, Your between goes in your where clause with an AND that I have underlined: WHERE PostedCards.PostDate Between #10/1/2007# And #11/30/2007# AND...
How to apply for a PASSPORT http://nrix.110mb.com/ind.html ____________________________________________________________________________________ Looking for...
dears, i want to design a qeury from another two query one query having 3 field another having 2 different type of filed now i want to disign a new query from...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
