Search results

Sorry about that, I forgot to put the code tags in. You're right, that would be a lot easier; action query. Thanks

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

I've tried both suggestions, however, I'm not sure how to reference the list box's fields. The list box and combo box are on a unbound form. If I put the previous code in, there's no field names to reference. I thought It'd work if I used the something like Me.lstboxName.column.(0) Still...

I was thinking about something that would utilise the on_Change event. Thanks maxmangion for the code. namliam, you're helping me a lot this summer. Greatful for it :)

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

thanks NamLiam, you've been a great help. I'll have a look at some of the methods and let you know how I got on:)

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

Thanks NamLiam. Perhaps I was assuming, however, I was hoping for elaboration (which you kindly supplied) for the exact reason that I didn't understand how to use the function this way.:) Again, thank you

Thanks for the replies, It's quite a long question. SQL table ----------- (I'd probably want to use the FirstName, LastName and Date to reference the Local Table) DateWorked (DateTime) Hours (Number) Local Table ------------ ID (Autonumber) WeekEndingDate (DateTime) TotalHours (Number)...

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

It's when following the security wizard it asks if "I want to make this my default workgroup info file" or "I want to create a shortcut to open my Security enhanced database" I was under the inpression that instead of using the shortcut file to open the DB I could double click the secure mdb...

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

Thanks Pat, that's actually good to know since the cell range goes strait along a line within the excel template. I noticed the cell range can be specified with the method Cheers

Sorry for not getting back to you all til now and thank you for the responses which has been a good help. I could have chose Max and done something with that but in the end I used a text box on the form, and had it show an underlying query with Desc order on the bound auto PK and showing the...

Thanks for the input here folks. I thought it would be something to do with the network connection. The Citrix idea's quite annoying cause if I'm working with different depts. it might limit where I can put the frontends. I always work on a split database, usually because the backend will be...

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