Search results

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

Hi All, I have a small question about a list box. On one of my forms I have a list box. One of the column fields, which is the bound column table ID) has a reference to the forms table ID, This is so the info in the list box is relevant to the forms records. I'll be using the list box as a...

Hi there. I have a similar post that hasn't really been answered probably due to it being fairly long and complex. So, I've broken it down. I'm trying to execute code from a command button on a form to add a new record to a table. CurrentDb.Execute ("INSERT INTO dbo_ComplaintDetail...

Hey Wazz, Thanks for getting back to me. You know, you maybe right about the design. The spec I got hadn't mentioned that but now you mention it. I'll have to ask about this because I think this could be a possibility. Thanks. In regards to the combo box idea for the stages. Well, the...

Hi there. Sorry about the heading being ambiguous. I Think I'll need some help with this one. The db I'm working on is for complaints. There are three stages of complaints. I have a main form and a sub form. The main form has the complainant and the subform, the details of complaint for...

Hi, sorry for the late response and thanks for the responses to my thread. I ended up not having to work on this. I'm sure I'll come up against similar again. I'm not sure I understand George. The Main forms record source is of a table that's just one of the relationships to the subform record...