Search results

That might be the problem. I have no idea about that. How do I fix it and what is it? fuga.

Hi, I created a delete query based on a duplicate query. For some reason access tells me I can´t delete the records when I run it. Has anyone had this problem? I´m sure I´ve done this in the past several times. thanks Fuga.

well if you don´t need it to look good, use subforms, linked to the ID of the main form (containing the general info) You set the subform to show continuous records. This way, each treatment entry in the subform will have the ID of the general info in the mainform. fuga.

Not sure if I understand, but don´t you need some kind of unique identifier of the accounts to identify them in the "already renewed" table? Fuga.

Are you exporting it manually? You could always export it as text, I guess? Fuga.

What have you tried so far? I don´t thinkt there should be a problem

Hi, I think you should consider putting your members info in one table, and the fees payments records in another table. Give your members an ID (Primary key) (for instance with an autonumber in your members table). Then link that ID to registered payments in your payments table. This way, you...

Maybe I´m wrong here, but I´m thinking you want an option group rather than checkboxes. This is an example that creates a query. The sql must be your own insert query of course. Mine is an update query, but I leave it as it is so you can see how to use variables. you put this code behind a...

When you want to create the subsamples, are yoiu registering a parentsample? Or is it the other way around? If you´re registering a parent sample and you wish to create subs, then you would execute some sort of append query on a table. As for the checkboxes, how many choices do you want to...

Hi again, Well you got some good help. I just wanted to mention that perhaps you´ll run into a problem later on if you don´t have your logging events in a separate table, so that you can add an unlimited number of entries for every unit. Fuga.

Hi, Can´t you just have now() as the default value of the field? Fuga.

Hi again, I just want to add that in sweden there can be problems with the .csv format because of the langauge settings (decimal sign etc, causing numbers to be interpreted as text and not being imported). They are usually easy to fix, but by then you may have lost some data. I don´t know...

Hi, well I would be somewhat alarmed by it. If you get importerrors then some data isn´t being imported, which can´t be good, right? As for the conversion failure, make sure you know what data it is that is causing it, and then check it in excel. I´ve had my fair share of this kind of problem...

I would solve this with queries and a temporary table linked to the excel sheet. First, you make an update query with inner joins on the workID field (from your temporary table to the ordinary). Second, you make an append query, probably with an outer join on the workID field (ie missmatch...

Yes! Thanks a lot! I had actually tried that, but I put "is null" in both fields, which gave me nothing of course. Great! Now it works. Fuga

Thanks for your reply. If I try that, access tells me a have ambiguous outer joins. Fuga.

Hi, I´m trying to create an append query that I need to append only new records. This is done on an hourly basis, which means that the date should be an inner join and the hour should be an outer join, right? However, access can´t handle this so I need help. If I do an append at 12 today, the...

Nope, if I set the update value in the query, the table updates just fine. It´s the value that access is supposed to "read" that doesn´t work. Is this a bug in access? I use 2003. Fuga.

I just saw Gemma-the-husky´s reply. I´ll try it. Fuga.

Thanks for your replies! This is the sql: UPDATE 15_QuarterlyGrouped INNER JOIN Tick15OHLC ON ([15_QuarterlyGrouped].[<DTYYYY-MM-DD>] = Tick15OHLC.Tick15Date) AND ([15_QuarterlyGrouped].orderID = Tick15OHLC.Tic150ID) AND ([15_QuarterlyGrouped].grouphour = Tick15OHLC.Tick15hour) AND...