Search results

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!

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...

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...

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

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...

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, I've been working on this code that I'll put behind a command button of a form. The code will delete the parent records child records, using the ID text box on the form for criteria so that, only that parent records child records are deleted. Because I wont to delete all child records I...

Hello, I've been working on a db that has SQL server backend tables. What's more important is that there are a lot of related tables and this is giving me some grief designing the forms. The form Im designing has quite a few subforms. one of the subforms record source's is a table that has...

Hello, I've looked through the forums for an answer to this and wouldn't expect this to be a hard one. On my form I have a list box which display three fields. I also have a combo box that I want to use to sort the order of each of the fields. The drop down will display the three fields...

Hello, I have a question... unsuprisingly In my DB, which is for employees and the positions they hold, I have to let users assign roles to existing employees, like a staff rotation. One person leaves which can start a domino affect of new role (position) assignments. So, I've used a...

Sorry to be a pain and ask another date question. The DB I’m working on has backend access tables and a single Linked SQL Server table which I’ll call “SQL table”. The Access DB is for Agency Staff and my present problem only concerns the SQL table and one Access table. The Access table has...

Hi there As the title suggests... Is an Access "2003" .adp project compatable with SQL Server 2005. When I try to invoke query builder for the recordsource on a form, for example, I'm getting a dialog saying: "This Version of MS Access doesn't support design changes with the version of SQL...

Hi There, Just a quick question. Anytime I've secured a database I've always used the option that creates a shortcut file and the DB will get accessed that way. The other option is to make the mdb. file the Default and access the DB through that file directly. I'd like to do just that...

Hi there Hope someone can help. Ive recently just finished a database. At the moment the frontend is being used on the server instead of the client pc. I know this should not be the case but it's happining that way because of citrix transitions with depts which I don't really know much about...

Hi There, Just as the title suggests, is there a way to open a report in Datasheet (Basically a query view). I'd just set up a query, however, I need to put underlying code into the report so that I can automate opening other objects when the report closes. I also need it to be in the...

Hi folks, I have a form that uses a text box that lists the last value from one of the fields. The text box has an underlying query that uses the last function to list the last value. it was working before, when I entered a value, along with requery, the textbox would change to that last...