Search results for query: *

I think if you use a recordset(rst) for whatever table, query etc. to which you wish to add a record Then type rst.Addnew This should add a new record to whatever recordset is associated with your rstvariable. This is the first time I've ever been able to give someone else advice. :-) I'm...

Thanks Channah and FancyPrairie, I failed to add that I am running Access on a full session through Citrix and Windows 2000 server.

Thank you for your time on this one. This is where it gets peculiar. I'm being logging in as myaccount, not the admin account, although, when I go to the Change Logon Password tab under "User and Group Accounts" the only thing there is Admin:. All other indicators point to...

I don't see how I can reset the password for the user Admin. The only way I get anything remotely close to a password is the "Change Logon Password" tab. But, it doesn't take the passsword for that account. Interestingly enough, I have tried to reset the password for the admin...

Everyone will love this one. :-) Ok, I started setting up users and groups on my database. There are three users: Admins Checkout myaccount and of course two groups: Admins Users Maybe I did something wrong. :-) But as far as I can tell, I'm logging on as my account which is an admin...

Are there other ways to execute code beside the events tab or through a macro?

Thank you very much. :-)

Does anyone know if the For Each...Next statement can be used on the records that are in a query? If so, how would one facillitate this with code? Thanks in advance. :-)

Thank you very much. :-)

I have a report (ie. report1) that is based on a query (ie. query1). There is a date field that I have in the query. I also have a form that is used to input two dates for a range of dates. Using VBA, I know that it is possible to sort a record by a particular field in the report. However, is...

Thanks SarahG :-) I guess I sometimes think the code has a specific function for everything. If you will, I missed the individual trees because I was looking at the forest. Thanks

Does anyone know if the DateDiff function can give hours and minutes? For example, the following code will give me the hours between dtmDown and dtmUp, but it will only give me a whole number. Is there a way to get hours.minutes? DateDiff(Interval:="h", Date1:=dtmDown, _...

Thanks. medium

Will ADODB recordsets work if EOF is true?

No, I'm not saving it before. I have played around with rstrecordsetname.update before doing the search. However, that didn't produce the desired result. The problem I have at that point though is getting the autonumber into a variable. My lack of success may have something to do with not...

I am currently trying to get a new record's id number assigned to a variable. I'm not too sure how to proceed. I've tried a recordset approach. However, that didn't seem to work. Moreover, I've tried getting the current record number but the actual record number is different from the...

Thanks Rick. Sorry haven't been able to reproduce the problem. I think the problem I encountered before was caused by something else. However, it showed up at the same time, or at least soon thereafter.

Frink, Thanks again. However, I'm having trouble figuring out how to implement what you said in the first paragraph about using Me![FieldName] Here's where my code is so far. Where and how would I implement the Me! ? More comments below the code. Public Function GetDesc() Dim strPartNo As...

Frink, Thanks for the post. Very helpful. medium

Using VBA in the past couple of months has definitely proven to be rewarding. However, I have run into a problem on which I need some assistance. I have a situation where I need to get information from the current record in a form. Then take that information and write it to a table. Does...