Search results

Well I guess I'd first like to know if what I want to do is possible. So, are you saying that what I am trying to do is not possible?

Hi, I have a really simple issue but can't figure it out. I have a table with a Race ID in it and I want to use this ID to get the race name and date and put them as the header on the report 'cos all results relate to this race. Simples! If I use a text box I just have a field in the...

So, is there a way of checking an Excel field's datatype in VBA?

Actually still need the cdate() too. :)

Dohh! Thanks for the question. Syntax error in SQL statement. I had it as: INSERT INTO TEMP_IMPORT001_20200203202457 (RaceRunnerNumber, RaceTime) VALUES (133, 00:15:54) When it should be: INSERT INTO TEMP_IMPORT001_20200203202704 ( RaceRunnerNumber, RaceTime) VALUES (133...

Hi, I am creating an import routine for users to import an Excel file of race results into my database. Now, my users are likely to be fairly non-techie so I want as foolproof a way of doing this as possible. So a) is there a way of knowing from the Excel file import what type of field it is...

Thanks Gasman. That was what I was looking for. I know there is an argument for the transferspreadsheet method but you need to know what format of Excel it is in for it to work and this would seem to be the answer I was looking for. Thanks again

It's fine. I know what I need. Thanks for the input

No this is to keep the runnerracenumber unique for a race which of course is what you want. Only one number per race. :)

Thanks Adam. It came from elsewhere but I guess it's fairly standard naming conventions. Actually, been to these 2 threads but I can't see a solution anywhere which enables me to interrogate the selected file for it's Excel version so I can use the right option on the transferspreadsheet...

Ah thank you! I new it had to be somewhere. Did an Alter table in the end :)

Hi, I was to create a secondary constraint on a table as a combination of 2 fields. How do I do this using the Access UI as opposed to doing it in SQL? Thanks Stephen

Hi, I want to import an Excel SS containing 2 columns: RacerunnerNumber and Racetime. I'm allowing the user to select Excel files from 2003 onwards. However, when using the transferspreadsheet method it requires you to specify a SS type. Is there a way of me knowing which SS type it is when...

Thanks Guys for all the helpful comments. Interesting the different approaches. Yes it would be nice to have the backend on a server but a small app like this and my current skillset and the users' locations potentially offgrid all mean that isn;t the case so I need a means of distributing...

Hi All, Now my database is at MVP stage I am now looking to distribute updates to the backend database. For now the copies are all local to each user so they will need to manually update the database themselves. What is the most efficient way of doing this? It means potentially new tables...

The values are from other fields but I will check what's actually being passed. Thanks

Hi, I have a form field which is taken form an Integer field on a table. I want to default a value into this field so have written a function which returns and integer value. However, when I set this function to be the default value of the field the form shows #Type in the field. What am I...

Sorry it's been a while. I haven't been able to access the forum for over a week. It just kept crashing on me with 'Database error'. Thanks. That was just testing. The issue was that I was preprocessing the report for a crosstab query and it had been put in design mode. Having done the...

OK, so it looks like that is working. I thought before jumping into the next phase I would ask you guys' advice. Now I have to run this query in VBA as the 'N' in TOP 'N' is variable and as you know it cannot be a variable in access. The final step is to produce a report from this data which...

Code from the Report Open event. I notice that the report Load event is not firing. I put a break point in there but it doesn't fire. Is that a clue as to what is wrong? Private Sub Report_Open(Cancel As Integer) Dim intControlCount As Integer Dim varOpenArgs As Variant varOpenArgs =...