Recent content by pablavo

It depends what path you want to go down; development or administration. That said, I'd get a quality book and some good videos if you're home based. CBT nuggets do some good videos that train towards certification and the vids are reletively cheap...

Great, Thanks Wazz, this'll be my first use of a loop statement. Don't know how I avoided it til now. I'll give it a go. paul

Hi there, hope everyone's well. I'm perplexed by a problem with a requirement. the db I'm developing is for projects that are reported on each year. there are 4 projects. Each project has 7 milestones. so tblProject has a one to many relationship with tblMilestone. All the names for each...

Hi there, hope someone can help with my problem. I've never really used Citrix before and went to set up an ODBC connection on someones PC so they could open an Access db. I can't find the ODBC program. Does anyone know how to set one up on a Citrix box? Thanks in advance for any help!

thanks for the help folks. I did chose the second of the two. I knew there was a way to do it with weekday but didn't know the syntax. Thanks.

Hi There. I would think that I could work this out but I can't All I'm trying to do is make sure that, if a user enters a date into a field and it's not on a friday, then a dialog will pop up telling the user it has to be a friday. it's a short date, I'm not sure if i'd use weekday...

Thanks for responding to my question.

Thanks folks for getting back to me. I should have actually specified that I had code in the form. Basically I don't want duplicate values in the table so I've used Dcount and if the number is more than 0 then it'll generate an error saying that the value has already been taken. It worked...

Hi folks I'm working on a db that I've recently upsized to SQL Server. One of my forms is for changing employees job titles which happens often. It's a continuous form that has two main fields, the name of the employee, and, the job title. The job title field is a drop down list which is...

Hi folks, This is just a quick question. I'm working on a db that has a SQL Server backend and Access frontend. I just want to make sure I'm doing this correctly. I've created views and am not sure if I import the view or link as a table using the ODBC? I would personally think it would...

Hi there, I would greatly appreciate if someone could help me with this. I’m working on a query that has a daily hours and daily date field. I’ve used the weekday function to group daily dates to weekly dates and subsequently, use the totals to show the sum of hours for each week. I've...

namliam, just thought I'd get back to you and let you and other folks know how I got on. I tried the weekday function just recently and it does technically work, however, I've been looking at the values from a query with the implemented function and calculating the values from the table with...

Thanks George. I've not read a lot of positive stories on this issue on the net. If I find a good work around I'll let you know too. Thanks Paul

Hi There, Just wondered if anyone new the right/best way to deploy the Access FE and BE on Citrix? More to the point, the FE? how would that be deployed? Any articles that may help would be greatful Thanks

I think I've found the answer, Me.lstRateOfPay.Selected(lstRateOfPay.ListCount - 1) = True